data validation
RH

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Data Validation

Data Validation

resolvedResolved · Low Priority · Version 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:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.05 secs.