Combo Box Default Value / Help Text,

[jerem]

Hi,

Is there a way to create a text default value for a control box that is bound to a number field?

I have a combo box that is bound to an auto number ID but displays text. Bound column = 1, Number of column = 2, Column width = 0; 4cm

I want to use sample text in all my controls (and I know an alternative would be to use the control tip text). In a text box it is easy, I just set the default value to that value and then a before_update event considers the text box empty if the field value is the default value (e.g. Name text box has: Name... as default value). This doesn't work with my combo box since the bound column is a number. I could create a value in the table but then it would appear in the drop box and it is messy.

Any other ways of doing this?

Cross:
http://www.utteraccess.com/forum/Com...-t2019797.html
http://www.access-programmers.co.uk/...87#post1364487

[ranman256]

You dont assign a text value to a number bound combo.
You assign the number that GIVES you the text value.
If you want NY to appear in the combo and the ID = 4 , then cboState = 4 will show NY in the box. (w ID column.width = 0)

[jerem]

Ramman: I know that. But this is not what I am trying to achieve.

[jerem]

For those facing the same issue, here is the solution:
http://www.access-programmers.co.uk/...d.php?t=266820