date format in form

  • Thread starter Thread starter Andre C
  • Start date Start date
A

Andre C

I havea small form which allows the user to enter dates which are
then used in turn to filter for a report.

I have set the format of the unbound fields to short date and populate
them on start up with Now() and Now()-31 to simulate a month.

Everything looks fine until I click on one of these text boxes to
change the date. Then the format changes to the date plus the time.

Help
 
Instead of using now() use Date() THis will only give you the date
info.
 
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

Forcing a date entry format of dd/mm/yyyy 1
Access 2 Digit year in Access Text Box 3
Medium Date format and calendar in Access 2007 1
#Type! error on form 6
displaying dates in UK format 10
Calendar control conflict with search 1
Excel Help with dates 2
Default Value =Date$() in UK Date Format 5

Back
Top