Validating Text fields on a Outlook form

[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

 

[Sue Mosher [MVP-Outlook]]

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] <> ""

 

[Guest]

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?

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

 

[Sue Mosher [MVP-Outlook]]

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

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?

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

 

[Guest]

Thanks again Sue. Works like a charm!

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

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?

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