Access VBA

Hi Mohammed,

A few things you can try...

1) You could try the Format function:

Format ( expression, [ format, [ firstdayofweek, [firstweekofyear] ] ] )

eg. Format ( yyyymmdd, "dd/mm/yyyy")

See more: http://www.techonthenet.com/access/functions/date/format.php

2) If it's an import, you can adjust it in Excel first, like this:

If A1 equals the yyyymmdd value, enter this in B1:
=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

... to get the proper format.

Hope this helps.

Regards, Rich