You can try resizing the combo box to a slightly larger size than the text
that will fill it. This should add the spaces above the text. To add spaces
before, you could preceed the data with spaces. In order to do that, you
will need to set up a query to feed the Combo Box. That query should take
the data from the table and add the spaces. Let's say the field was called
FirstName. You would set the field in the query to be:
FirstName2: " " & FirstName
This would add 5 spaces before the FirstName. Your ComboBox would use the
FirstName2 field.
You might need to strip the spaces out by using the "len", "right" command.
Let's say the combobox is called cmbName. You would use:
'***Code Start
dim varFirstName as String
dim varFinalFirstName as String
varFirstName = me.cmbName.Value
varFinalFirstName = right(varFirstName,(len(varFirstName)-5))
'***code end
This is going to find the length of the full field, subtract the 5 spaces,
and use the "Right" command to pull on the FirstName.
HTH,
Kevin
