Validating Text fields on a Outlook form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form with a couple of text boxes that I need to require input for.
I do not want to use the generic message not specific to the textbox the user
is in but I cannot fiqure out how to create a formula to use the dialog box
which I can specifiy a message when the validation fails.


My value tab under properties is bound to an outlook property but I am
unsure which function to user to flag for not text data. I have done a search
on outlook help to no avail.

Please help! Todd
 
If the name of the field that the text box is bound to is Field1, then the
validation formula to make sure the user has entered something in that text
box would be:

[Field1] <> ""
 
Thanks a bunch Sue. Works Great! One more quick question if you would be so
kind. What would I use as a validation formula for a date field mm/dd/yy that
the user could only input a future date?

Sue Mosher said:
If the name of the field that the text box is bound to is Field1, then the
validation formula to make sure the user has entered something in that text
box would be:

[Field1] <> ""

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



bradleyta said:
Hello,

I have a form with a couple of text boxes that I need to require input
for.
I do not want to use the generic message not specific to the textbox the
user
is in but I cannot fiqure out how to create a formula to use the dialog
box
which I can specifiy a message when the validation fails.


My value tab under properties is bound to an outlook property but I am
unsure which function to user to flag for not text data. I have done a
search
on outlook help to no avail.

Please help! Todd
Click to expand...
Click to expand...
 
I haven't tested it, but I'd start by trying something like:

[Field1] > Now()

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



bradleyta said:
Thanks a bunch Sue. Works Great! One more quick question if you would be
so
kind. What would I use as a validation formula for a date field mm/dd/yy
that
the user could only input a future date?

Sue Mosher said:
If the name of the field that the text box is bound to is Field1, then
the
validation formula to make sure the user has entered something in that
text
box would be:

[Field1] <> ""

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



bradleyta said:
Hello,

I have a form with a couple of text boxes that I need to require input
for.
I do not want to use the generic message not specific to the textbox
the
user
is in but I cannot fiqure out how to create a formula to use the dialog
box
which I can specifiy a message when the validation fails.


My value tab under properties is bound to an outlook property but I am
unsure which function to user to flag for not text data. I have done a
search
on outlook help to no avail.

Please help! Todd
Click to expand...
Click to expand...
Click to expand...
 
Thanks again Sue. Works like a charm!

Sue Mosher said:
I haven't tested it, but I'd start by trying something like:

[Field1] > Now()

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



bradleyta said:
Thanks a bunch Sue. Works Great! One more quick question if you would be
so
kind. What would I use as a validation formula for a date field mm/dd/yy
that
the user could only input a future date?

Sue Mosher said:
If the name of the field that the text box is bound to is Field1, then
the
validation formula to make sure the user has entered something in that
text
box would be:

[Field1] <> ""

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hello,

I have a form with a couple of text boxes that I need to require input
for.
I do not want to use the generic message not specific to the textbox
the
user
is in but I cannot fiqure out how to create a formula to use the dialog
box
which I can specifiy a message when the validation fails.


My value tab under properties is bound to an outlook property but I am
unsure which function to user to flag for not text data. I have done a
search
on outlook help to no avail.

Please help! Todd
Click to expand...
Click to expand...
Click to expand...
 
Back
Top