Form with required fields 2

[1angryadmin]

Hello All,

I recently inherited an access database which has forms with required fields. The users requested i do not require 3 of the fields which are currently required, because they are lazy. I am much better with asp then i am with access.

Please help...(this should be easy right?)

 

[scriverb]

The fields in the table have a property that is probably set to Required: Yes. Change this value to No. Also, you should check the Validation Rule for the text box control on the entry form. This may require a certain value to be entered.

Good luck.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[1angryadmin]

if i open the form in design view

then right click on the field and choose properties

no where does it seem to say "Required: Yes

 

[KenReay]

Hi

Bob said "The fields in the table ", you need to open the table in design view not the form. While you are in there you may also wish to set the allow zero length property to true, as well as setting Required to false

You also need (as Bob said) to check the controls for validation properties, this you do in form design

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[1angryadmin]

thank you both...i have now enabled the users to be even less productive hehe

 

[scriverb]

You have to open the table not the form. The table is where the Required property is located. If it is an attached table to an external database then you have open that external database and modify the property there.

You can tell if the table is external to your database if there is a black arrow to the left of the table name in the table name list.

If you have more questions please post back.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]