Office 2007 - date format to upper case

[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

 

[tina]

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

 

[tony wong]

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

 

[tina]

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

 

[Tony]

Thanks a lot.

it works.

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

 

[tina]

you're welcome

Thanks a lot.

it works.


"tina" <[email protected]> ¼¶¼g©ó¶l¥ó·s»D[email protected]...