Change the display of field values on a combo box

[johannaellamay]

Hi! I'm trying to sort and filter a continuous form. I want to sort by descending and ascending, but I also want to have a combo box for filtering. For example, there a combo box for sorting with Value List as the RowSourceType, the list would be "Ascending" and "Descending", and there should be another combo box to choose the field to be sorted with RowSourceType as Field List from a query. My field names are: "LastName", "FirstName", "MiddleName". But I want them to appear as "Last Name:, "First Name", "Middle Name". I want to be able to change the display of the field names within my combo box which should come from my query. How is that possible? I already tried to put caption in the properties but it didn't work.

 

[namliam]

How about manually entering the values into the combobox, use 2 columns (hiding the first column from view for the user)
TableName, DisplayName
LastName, Last Name
FirstName, First Name
MiddleName, Middle Name

You can then easily pick which column to sort on

 

[johannaellamay]

Hi! Thanks for your reply. I was now able to solve it based on the instructions from:

http://bytes.com/topic/access/answers/881729-have-combo-box-list-field-captions

 

[namliam]

Dont see how that is relevant to this question though I only scanned it quickly.

Glad you found a solution that works for you.

 

[johannaellamay]

Dont see how that is relevant to this question though I only scanned it quickly.

Glad you found a solution that works for you.

Hmm. Actually, I spoke too soon! HAHA. It didn't work. I was able to change how it looked on the Field List but Access tells me that there is no such field.

I couldn't understand though how to execute your instruction. How do I make two columns from a Field List?

 

[namliam]

You cant, you type them manually by changing the combo's values from rowsource to manual entry and type them in Manually.

 

[johannaellamay]

You cant, you type them manually by changing the combo's values from rowsource to manual entry and type them in Manually.

Hi! Thank you so much. It worked!