leading zeroes on report date

[mark r]

some people suggested that in order to have leading zeroes
show up on dates on a report I either need to

1. specify an explicit date format mm/dd/yyyy

or 2. reset a windows regional setting to make short date
format use leading zeroes.

these both sound like solutions, but these people haven't
clued me in on how and where to implement these ideas.
I don't know how to find or set windows regional settings.
I don't know where you type in explicit formats (on the
property form of a report text box? or in the table
definition of the data field? or both?

 

[Allen Browne]

For the Windows settings:
1. Open the Windows Control Panel.

2. Choose the Regional Options.

3. Locate the setting for Short Date. (The actual tab and position is
different in different versions of Windows.)


To set the Format property of the text box on your report in Access:
1. Open your report in design view.

2. Right-click the date text box, and choose Properties.

3. On the Format tab of the Properties box, set the Format property.

 

[Jeff Boyce]

Mark

Not sure how this is a formscoding newsgroup question ...

Changing your table field's format won't change any existing reports' use of
that field (but will affect all future reports built on that field).

Have you tried changing the format of the report control?

 

[Mark]

Hi,

To set windows regional settings in Windows XP go to the Control Panel from
the Start button, then select the Regional and Language Options. On the
Regional Options Tab Click on the Customize button. Then select the Date Tab
and edit the Short Date format.

To explicitly set the format of a text box on a form or report, select the
text box (in design view) and press Alt+Enter to open the Properties. Find
the Format property and enter mm/dd/yyyy

For a table open in design view select the field in the top pane, press f6
and edit the Format property on the General Tab.


Hope this helps

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/