Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Optional Fields

Status
Not open for further replies.
rchen

rchen

IS-IT--Management
Mar 7, 2003
16
0
0
SG
I am adding a new record and one of the fields is optional. If they click the button, i get an error of cannot have zero length string. How can I avoid this error, if someone does not have to put something in that field? Thanks.
 
Sort by date Sort by votes
In Access, go to the table's design view and make sure the optional field have the following settings:
Required : No
Allow Zero Length : Yes

HTH

Choo Khor
choo.khor@intelebill.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cr84net2
  • Locked
  • Question
I need to join 5 tables with identical fields then reference the records by table
Replies
4
Views
88
guitarzan
guitarzan
wbodger
  • Locked
  • Question
Pre-populated form fields problem
Replies
3
Views
50
wbodger
wbodger
joepeacock
  • Locked
  • Question
.NET C# Newb - Form fields not posting???
Replies
1
Views
61
johnwm
johnwm
evr72
  • Locked
  • Question
if specific fields filled out then after submit open more fields 2
Replies
4
Views
28
evr72
evr72
jeellison
  • Locked
  • Question
disabling fields 1
Replies
16
Views
37
jeellison
jeellison

Part and Inventory Search

Sponsor

Back
Top