Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation rule on a control using a function

Status
Not open for further replies.

richardii

Programmer
Jan 8, 2001
104
GB
I am using a function as a validation rule for a control on a form. The function changes the caption depending on the control value. Problem is, I always see the Validation Text (ie the validation always 'fails').

Can I supress the Validation Text (the function does what I want - I don't want any validation text!)

Thanks.
 
The post is somewhat confusing. If the validation fails, you should see the text, ... the function works ... ??

Please re-post with some clarification. Perhaps the validation code - and an indication of WHAT it is doing that you dont want (e.g. comment before/after the lines which shouldn't be actie - but are.
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over
 
Thanks. I've worked it out now. I made the validation function always return null. I then put:

fValidation() Is Null

in the Validation Rule, and the Validation Text doesn't come up (because the rule's always satisfied).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top