Format a Date Using Field Properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to do this in Visual Basic and Assembler but having trouble with
the Syntax in Access

On the Format Event on the Properties Menu for a Field I have ("mm/d/yy")

I have been guessing and trying to find an example on the WEB and in Access
Help and still cannot determine what I am doing wrong.

All I want to do is display the year as two characters instead of four!

On my Format Tab, On the Format Line (The first line) What Syntax does it
want to do this very simple task!

Thanks in Advance

Len
 
I know how to do this in Visual Basic and Assembler but having trouble with
the Syntax in Access

On the Format Event on the Properties Menu for a Field I have ("mm/d/yy")

I have been guessing and trying to find an example on the WEB and in Access
Help and still cannot determine what I am doing wrong.

All I want to do is display the year as two characters instead of four!

On my Format Tab, On the Format Line (The first line) What Syntax does it
want to do this very simple task!

Thanks in Advance

Len
Click to expand...

drop the quotes
 
Doug;

This does not work either. Displays #Name? for a Date.
Thanks

Len

Will continue trying to get it to work.
 
Len said:
Doug;

This does not work either. Displays #Name? for a Date.
Thanks
Click to expand...

Are you saying that with no format property setting you get a date value
returned (just not in the format you want) but when you enter a format
property you get #Name?

Or do you get #Name all the time? That suggests that you have the field
name spelled wrong or that it doesn't exist in the RecordSource.
 
Len said:
Fred;

Same result. Date displays as #Name?

Thanks for the suggestion.

Len
Click to expand...

Not in the Format EVENT property. Use the Format property for the TextBox.
You will find it on the Data tab of the property sheet.
 
Back
Top