Selecting an item from a DataCombo using the Index ID

[rickyoswaldiow]

Good morning all. I have a DataCombo control (not to be confused with ComboBox) which is populated with data. I am wondering how I can display the Description (ListField) text by referencing the Index ID (BoundColumn) i.e.

I have three entries in the DataCombo
0. Red
1. Green
2. Blue

I want to reference which is to be shown by the number, but I want the string to be displayed.

 

[rickyoswaldiow]

I've found the source of my problem. I was using the .BoundText property which was right, but we were setting it to:

Me.cboDataCombo.BoundText = "" & !Record

The mistake here is including the '"" &'. Simply removing this fixed the problem.

 

[BobRodes]

The concatenation of a blank string to a field value is to convert any null values in a field to a blank string. If you don't, you'll get an "invalid use of null" error, because you can't assign a null value to a text box's text property. When you concatenate an empty string to the field value, then if there's a value in the field, it won't be changed, and if there isn't, it will be changed from Null to a blank string.

I'd recommend that you test the behavior of your control when encountering a null value if you haven't already.

Bob