General information
Category:
Forms & Form designer
Title:
Combobox displayvalue shows a blank
Hi,
Is there a way to get the combobox.displayvalue (a character value)to show the combobox.value despite the combobox.controlsource value is not spelt the same?
For example: combobox.controlsource is set to tableA.field1. The rowsource is set to tableB.field1. If a name in tableA.field1 is spelt like "Ann Oswald" and in tableB.field1 spelt like "Ann OSWALD" the combobox.displayvalue shows "" and the combobox.value is "Ann OSWALD", i.e. the combo display is blank. If the name is spelt the same way in both tables, ie tableA.field1=tableB.field1="Ann Oswald" the combobox.displayvalue="Ann Oswald"
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only