Re: Change Date Format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The name error usually occurs for a different reason.

Make sure you are settig the format PROPERTY for the control. If you are
entering

=Format([myDateField],"mm/dd/yy") as the control source and the control's
name is "MyDatefield" you will get an error. Access can't tell if you mean
to the date field or the control. If you are doing this try changing the
name of the control to txtMyDateField.

As I said, you should probably have the control's format properties set as
below

Format: "mm/dd/yy" (on Format tab of the properties dialog)
Control Source: [MyDateField] (on the data tab of the properties dialog)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"John Quinn" <JohnQuinn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C09E3990-ACD1-42B4-9D3F-856DDCF425D3@xxxxxxxxxxxxxxxx
John;
Thanks for getting back to me. Yes I have tried this and all I get
on the report is #Name?

The data comes from a field in the table defined as a Date/Time
field.

Still fighting the problem. I have called some programmers who know
Access and they are also trying to help. I can change my whole
application
around, but the IBM guys are really having a ball at my expense.

Thanks Again.

John

"John Spencer" wrote:

You should be able to set the format property of the control to
"mm/dd/yy"
to get it to show 06/01/05 for June 6, 2005

Is that what you have tried?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"John Quinn" <JohnQuinn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9BE4D00-1B13-4ACD-A81A-775B863DE59C@xxxxxxxxxxxxxxxx
I am trying to print a date field as 2 character(s) Month, 2
Character(s)
day, "Need Leading Zeroes", and two diget year.

I select properties on my date field. Go to my Format Tab, and on the
Format Line have tried for days to enter the syntax it wants.

It is hard to say how many I tried!

Can I just put the format in this text box without having to try to
learn
VBA?

Thank You for any help!

John Q





.

Relevant Pages

  • Control format property in OnFormat event
    ... I have added an extra field to determine the format type. ... while setting the format property seems ... Eventual report layout.... ... I want to have control of the formatting of the week number controls... ...
    (comp.databases.ms-access)
  • Re: Data Report control questions
    ... There is a RptImage control, which lets you display a bitmap. ... Format property containing a formatting string. ... "The Format property supports the same set of format expressions as the Format ... You will probably find that the Data Report tool in VB6 is fairly limited. ...
    (comp.lang.basic.visual.misc)
  • Re: time calculation problem
    ... John Spencer wrote: ... Al's previous formula though it didnot work gave me the format i wanted. ... The OP has confirmed that he is storing dates and times in separate table fields, as editing a "General" date format is messy, and he's keen to keep things simple for the users. ... In the former I was using the DTPicker control, which seemed to allow me to use two controls on the same underlying field, and somehow managed to avoid problems when I edited either: ...
    (microsoft.public.access.gettingstarted)
  • Re: Changing font colors in Continous Form for one record
    ... I had the format set to Currency, ... --Right Click on the control and show properties ... --Enter the specified format in the Format property ... Besides, with a continuous form, whatever I put in reacts with the hole ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to display negative numbers in parentheses in Access Repor
    ... "John Spencer" wrote: ... -- If the properties dialog is not showing, then right click on the control ... -- On the format tab, select the format property and enter the suggested ... go into a report and click on a control field, ...
    (microsoft.public.access.reports)