I have access 2007 and want to know how to make a rule that a data entry on a form must begin with www. ?
Thanks
0
Access Question
Started by iwz, Apr 13 2008 12:33 PM
2 replies to this topic
#1
-
- Members
-
- 174 posts
Young Padawan
- Gender:Male
- Location:UK
- Interests:Photography, Gaming, Web-design.
Posted 13 April 2008 - 12:33 PM
#2
-
- Members
-
- 1,888 posts
Honored X Staff
- Gender:Male
- Location:Antwerp (Belgium)
Posted 14 April 2008 - 02:39 AM
in your design layout, if you need to use the hyperlink parameter type:
the bad news is, you cant use a "entry mask", but the good news is you can always make a "validation value"
fill in validation value: LIKE "www."
and put some text at the validation text to make sure ppl know they did something wrong and need to fill in www. first.
this should work.
the bad news is, you cant use a "entry mask", but the good news is you can always make a "validation value"
fill in validation value: LIKE "www."
and put some text at the validation text to make sure ppl know they did something wrong and need to fill in www. first.
this should work.
#3
-
- Members
-
- 174 posts
Young Padawan
- Gender:Male
- Location:UK
- Interests:Photography, Gaming, Web-design.
Posted 15 April 2008 - 07:10 PM
Thanks, it was LIKE "www.*"
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
