Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
data validation

ResolvedVersion 2003

Lisa has attended:
Access Intermediate course

Data Validation

What does 'Allow Zero Length' do?

RE: Data Validation

Hi Lisa

Thanks for your question

A zero length string is simply represented by two quotation marks with no space in between them; i.e. "".

Setting this property to yes, on a field where an entry is required allows the user to skip the field by simply typing "".

Regards

Stephen

Access tip:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.