date in unbound box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound box with quite a bit of text, an if formula and a field
from the table of the students date of birth (this is all in a letter). THe
students date of birth in the query and in table is medium date (1-Jan-83)
but when i include this in unbound box it comes as 1/1/1983 is there any way
of making it into medium date in the unbound box?
 
Access actually stores a date/time field as a number, so if you want a
particular formatting, you need to specify it.

Example Control Source:
="Birth date: " & Format([DateOfBirth], "Medium Date")
 
Back
Top