Selecting Different Value from Select List

[emhill57]

I have a select list that is retrieving its entries from a field that is 4 characters, right-justified. I want to somehow display the entries with the leading blanks trimmed but when the selection is made, I need the returned value to be right-justified so it will filter correctly. I know I can use the TRIM() function if my query to get the values in my select list but how would I return them right-justified?



Thanks in advance!!!!

[ranman256]

use a form. Set the text box to right just.

[emhill57]

The list box is in a form. I want it to display with NO leading blanks but when it is selected I need it to "pass" the selection as right justified because I have some VBA code on the AfterUpdate event of the select box. I use the selection as part of a filter string against a database and it needs to be 4 characters right-justified to compare to the field in the table.

Hope this explains it a little better that I did to begin with.

Thanks!

[John_G]

Use a two-column list box, with a query that selects the same fields twice from the source table, once with the leading blanks, the second without. Make the column with the leading blanks the first column, and make its width zero so that it does not display. Set the bound column of the list box to 1 (the one with the blanks); that is the value the VBA wil use.

[emhill57]

Thanks John_G!!! I'll give that a whirl!

[emhill57]

John_G... That worked!!! Thanks so much!!! This novice is gaining knowledge everyday!!!