want to make the default output blank, not a value

  • Thread starter Thread starter mike
  • Start date Start date
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
 
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.
 
Back
Top