Custom format a date in Access Table for m/yyyy

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

Guest

In M/S Office 2003 Access Table, I want to set a custom date format to show
m/yyyy with the day omitted (not known). Can this be done?
 
In M/S Office 2003 Access Table, I want to set a custom date format to show
m/yyyy with the day omitted (not known). Can this be done?
Click to expand...

You can display the date field as 8/2005 by setting the control's
Format property to
m/yyyy

HOWEVER this only effects how the date is displayed. You must still
enter a valid date including the day when entering the date.
 
Thanks, Fredg. I have a situation where I have a set of dates (without the
day) to enter in the access data base. I guess I can fake the day since it
will not be displayed.
 
In fact Access will automatically fake the day for you by entering the 1st of
the month. On your data entry form set the Format property of the control
bound to the field to:

m/yyyy

and its InputMask property to:

90/0000;0;_
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert into (dates format) VBA 6
printing report with date 3
Recordset Findfirst Date Issue 0
Running Total 10
Date format 4
Set British Date Format 5
Date format in a report 2
SQL CREATE TABLE DATE issue MS Access 4

Back
Top