Re: leading zeroes on report date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 06/17/04


Date: Thu, 17 Jun 2004 20:29:54 +0800

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.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"mark r" <anonymous@discussions.microsoft.com> wrote in message
news:1db8101c45465$e0aa6530$a501280a@phx.gbl...
> 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?


Relevant Pages

  • Re: Number formats inconsistent
    ... Excel picks this up from a windows setting: ... change the negative currency format to show 's. ... We run Office 2003 on a Citrix terminal server. ... We tried changing the international settings on the server (stored outside ...
    (microsoft.public.excel.setup)
  • Re: Excel 2000 Header Date Format..
    ... I set my Windows short date settings this way: ... Control Panel, Regional and Language Options, Regional Options tab, Short date: ... I can't figure out what to change to get the proper date format. ... I'm using Windows XP home edition SP3. ...
    (microsoft.public.excel)
  • Re: formatting of row depending on cell value
    ... Depends upon your short date format in Windows settings. ... Gord Dibben  MS Excel MVP ...
    (microsoft.public.excel.newusers)
  • Re: Adaptec AHA-2940AU vs AHA-1530P
    ... 1/ Under windows, run the device manager and look for the scsi drive. ... settings and verify that the "init 13 unit" option is turned on. ... 2/ Drop into a DOS box and run Fdisk from there. ... reboot into windows and format using "My computer" ...
    (comp.periphs.scsi)
  • Re: Serious search problem
    ... "Robin Bignall" wrote: ... and ran all of the virus and malware checkers again. ... On the IE properties windows you will see these Taps: ... Click Privacy Tab and make sure your Privacy settings at least Medium High, ...
    (microsoft.public.windowsxp.help_and_support)