Report Field Formatting with unbound control box.

  • Thread starter Thread starter DJW
  • Start date Start date
D

DJW

I have an unbound control box in my report that has the following sentence
containing two seperate fields. I want to format fields the report in a
different manner than the actual format in the table. The two field types I
am having trouble with are Currency and Date.

Example: = "On " & [Date] & ", " & [LastName] & " was billed" & [Amount].

I would like the date displayed as Aug 1, 2003 instead of 08/01/2003. I
would like the amount to show up as $124.00 instead of 124.

Any help is greatly appreciated.
 
DJW said:
I have an unbound control box in my report that has the following sentence
containing two seperate fields. I want to format fields the report in a
different manner than the actual format in the table. The two field types I
am having trouble with are Currency and Date.

Example: = "On " & [Date] & ", " & [LastName] & " was billed" & [Amount].

I would like the date displayed as Aug 1, 2003 instead of 08/01/2003. I
would like the amount to show up as $124.00 instead of 124.
Click to expand...

Example: = "On " & Format([Date], "mmm d yyyy") _
& ", " & [LastName] & " was billed " _
& Format([Amount], "Currency")


BTW, you should really change the name of the date field. "Date" is the name of
a function in Access and when you name an object of your own with the same name
as a built in object you are asking for problems. The square brackets *should*
identify the object as yours instead of the function, but it would be easy to
forget those brackets somewhere and get unexpected results.
 
Back
Top