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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar