Office 2007 - date format to upper case

  • Thread starter Thread starter tony wong
  • Start date Start date
T

tony wong

i wish to show date in report as "JUL" instead of "Jul"

i can only do it by converting date to string first and report with ">"
format type.

is there another simple way to do it?

Thanks.

Tony
 
well, essentially, that's how i would do it. but you don't say *how* you're
converting the date to a string. a simple way is to use the Format()
function at the report level. instead of assigning your date field directly
to a textbox control's ControlSource property, set the ControlSource
property as follows:

=Format(DateFieldName, "mmm d, yyyy")

replace DateFieldName with the correct name of the field, of course. use
whatever format you need inside the double quotes, the above is just an
example. then set the textbox control's Format property to
hth
 
Hi tina

Thanks a lot for your reply.

i can only locate the controlsource property in textbox control

what mean "set the ControlSource property as follows:"? where is it?

Tony
 
it's right where you found it, tony, in the textbox control's Properties
box. click on the ControlSource "line" in the Properties box and type in the
expression i posted, *including the = sign*. or you can copy it from the
post, and paste it in. make the changes you need to make to the expression,
as i explained before.

hth
 
Thanks a lot.

it works.


tina said:
it's right where you found it, tony, in the textbox control's Properties
box. click on the ControlSource "line" in the Properties box and type in
the
expression i posted, *including the = sign*. or you can copy it from the
post, and paste it in. make the changes you need to make to the
expression,
as i explained before.

hth
Click to expand...
 
Back
Top