Format Field

[PR]

I am trying to format a field in the query panel... but can not seem to get
this to work...

I am using :

DOB: Format("DOB","dd, mmm yyyy")

can anyone let me know what is wrong with this...

Regards - Paul

 

[Marshall Barton]

I am trying to format a field in the query panel... but can not seem to get
this to work...

I am using :

DOB: Format("DOB","dd, mmm yyyy")

can anyone let me know what is wrong with this...

You should use a different name for the calculated field,
but I suspect that the problem is that DOB is not a
Date/Time field in the table. I may be off on the wrong
track, but ir's all I can come up with given "can not seem
to get this to work..."

Generally, you should do the formatting using the Format
**property** of a text box on a form or report, not in a
calculated query field.

 

[Duane Hookom]

Also, the expression
DOB: Format("DOB","dd, mmm yyyy")
doesn't include a field name inside the Format. "DOB" is just a string
value, not a field reference.
Try:
DOfB: Format([DOB],"dd, mmm yyyy")

As Marsh suggested, I do all of my formatting in controls on forms and
reports.

 

[Marshall Barton]

Sheesh, I completely missed that. Good catch Duane.