MS Access Date Field Formating

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I am trying to get a feild in my databse to display a date
in the correct format. I have the default vaule set to
Format$(Date(),"dd/mm/yyyy") so it will auto populate the
date. BUT I want the date to look like this 01/01/2003 and
I can not figure it out, I looks like this 1/1/2003.

I want it to have a 2 digit day and month, but dd/mm/yyyy
just formats it like 1/1/2003 not 01/01/2003

PLEASE HELP I AM GOING CRAZY
 
Ryan said:
I am trying to get a feild in my databse to display a date
in the correct format. I have the default vaule set to
Format$(Date(),"dd/mm/yyyy") so it will auto populate the
date. BUT I want the date to look like this 01/01/2003 and
I can not figure it out, I looks like this 1/1/2003.

I want it to have a 2 digit day and month, but dd/mm/yyyy
just formats it like 1/1/2003 not 01/01/2003

PLEASE HELP I AM GOING CRAZY
Click to expand...

No need for the men in white coats yet.

Don't bother trying to format the Default Value; leave that set to just
Date(). But set the field's Format property to "dd/mm/yyyy" -- without
the quotes -- and you should be all right.
 
Back
Top