Dynamically Required form fields


J

Jamie

Is it possible to dynamically make elements in an Outlook
form required if a checkbox in that form is clicked?

Example:
Do you need a report created: Yes No

If yes fill out the following:
Name of report (etc) <-- I want these required IF the
above answer is Yes.

Can this be done?
 
Ad

Advertisements

J

Jamie

Thanks, Sue. I'm afraid that's still over my head. I'm
just in the early stages of figuring out how the VBScript
works with forms and don't know the syntax yet. Do you
have an example you can point me to?

Thanks again,
Jamie
 
Ad

Advertisements

S

Sue Mosher [MVP]

It's pretty straightforward:

Function Item_Write()
Set MyPage = Item.GetInspector.ModifiedFormPages("MyPage")
Set CheckBox1 = MyPage.Controls("CheckBox1")
If CheckBox1.Value = True And _
Item.UserProperties("My Property") = "" Then
Item_Write = False
MsgBox "Please enter a value for My Property"
End If
End Function

The statement Item_Write = False cancels the saving of the item. See http://www.slipstick.com/dev/propsyntax.htm for the other basics of referencing form controls and custom properties.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top