want to make the default output blank, not a value

M

mike

I am trying to use a form to export values to a database
but on some of the drop-down boxes I want to output a
blank if there was nothing entered in the box. Otherwise
I want to output what was entered. Here is my code as it
stands, I just am not sure how to edit it to perform the
desired task.

if Item.UserProperties("Output2")<>"" _
then rst.Output2 = Item.UserProperties
("Output2")

Any help would be great.
Thanks
 
S

Sue Mosher [MVP-Outlook]

This statement -- without the If -- covers all cases:

rst.Output2 = Item.UserProperties("Output2")

If the "Output2" property is blank, then rst.Output2 gets set to blank.
 
Top