By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

A validation rule question

P: n/a
I created a function to test to see if entered text has a '.' in it,
The code seems to work but the validation always fails even when 'true' is
returned.

i put
= myfunction in the validation rule and ny validation messages always
displays.

What am I doing wrong

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
GD
Danny wrote:
I created a function to test to see if entered text has a '.' in it,
The code seems to work but the validation always fails even when 'true' is
returned.

i put
= myfunction in the validation rule and ny validation messages always
displays.

What am I doing wrong


Post the function definition and exactly what you have entered in the
Validation Rule blank.

Nov 13 '05 #2

P: n/a
Ok, if I do
myfunction([field])) = True, it will work, but now another error.
I get a type mismatch in validationproperty when I enter a null value
I would like the null value to be accepted also

"GD" <gy**********@jmjservices.com> wrote in message
news:0%***************@fe1.columbus.rr.com...
Danny wrote:
I created a function to test to see if entered text has a '.' in it,
The code seems to work but the validation always fails even when 'true' is returned.

i put
= myfunction in the validation rule and ny validation messages always
displays.

What am I doing wrong


Post the function definition and exactly what you have entered in the
Validation Rule blank.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.