John,
This worked great. I put it in the form property. I will just modify it for other fields.
Thanks,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, October 9, 2015 10:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Required info
Ooops. Missed a bracket:
Len([GphContribution]) >= 10
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 9, 2015, at 5:11 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Instead of using Required, use the Validation Rule property. In that property, put:
Len([GphContribution) >= 10
In Validation Text, you can put any custom error message you like - for example:
Length of the Contribution field must be at least 10 characters.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 9, 2015, at 3:37 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I am working on data integrity in my database. Access 2013
In the table I am setting the required field to YES. However, I do not like the message that I get when an entry is not made in the form.
This field is a text field. I am hoping to require an entry and I would like to make sure the entry is at least 10 digits long but I can't figure out how to do that.
The field name is GphContribution
If the field is null or two short I will open a text box.
Could someone help me with the counting language?
Thanks,
Bill Singer
Mpls, Minnesota
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar