Format Field

  • Thread starter Thread starter PR
  • Start date Start date
P

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
 
PR said:
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...
Click to expand...


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.
 
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.
 
Back
Top