date field

  • Thread starter Thread starter mccoy
  • Start date Start date
M

mccoy

i would like to prevent the users to input back dates on the date field on my
dbase

can anyone help me on this

thanks
 
mccoy said:
i would like to prevent the users to input back dates on the date field on
my
dbase
Click to expand...


By "back dates", do you mean, dates before the current date? Keeping them
from entering dates before the current could be accomplished by means of a
validation rule like this ...
= Date()
Click to expand...

.... set either for the field in the table's Design View, or for the control
in the form's Design View, or both.
 

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

Clear fields button 3
Add one year in second combobox in vba 0
Updating tables when you input new data 0
Date Field 7
Excel How to get the number of days an item was opened from the today's date. 14
Problem with calendar pop up XP - Access 2002 2
Date Formatting 1
Using Access offline and then syncing back into main dbase 5

Back
Top