Enable a field based on other input field

[softpro]

Hi,

1.
Can I enable a field based on other input field's enabling status. Right now, I am doing it in the respective after_update event. Is there any other efficient way to do this?

2.
Also, can a date field accept the format 10302001, but access gives error for this. But the requirement is to accept this and consider it as 10/30/2001. How to do this?

3.
How to maximize a form, right now I am doing in form load docmd.maximize, can I set it in form's properties, or is there a better way other than this?


Thanks a lot.

***

 

[Pat Hartman]

Why would you need to force the user to ALWAYS enter 8 digits to enter a date? If you use a bound date/time field, you can get by with entering as few as three characters to enter a date - 1/1 plus Access won't let you enter an invalid value. If you do the entry your way, you'll need to use an unbound field and add code to convert it to a valid date and place the date into the table field. You need similar code in the Current event of the form to convert the stored date back to this text format.

If the problem is that you need dates in that format to export to another system, there are much better ways to handle the problem.