IIf

[brbarto]

I have created a combobox with account numbers. I am having problems, I think, because the numbers (ex 2-70000) have a hyphen. I was never able to get the hyphen displayed in the combobox. Is this possible?? When an account number is selected, then a hyphen will appear on the form. I am using an input mask (0\-00000).
Also, if you start entering a number, the AutoExpand does not work unless I take the hyphen out.

Thanks for any help

 

[crose7227]

Im not sure what the problem is but it works just fine over here land of milk and Honey

 

[genomon]

Try making the value a string (CStr function) when you load the combo box and/or enclose it in double quotes.