Format a multi-variable dropdown

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I display the results of a query in a dropdown for the user to make a
choice. There are three variable in the dropdown.

Because these variables are different lengths, the dropdown is messy.

Is there a way to evenly space the variables so that each would be in it's
own column, or something similar?

Examples

From:

St Louis Missouri Tuesday
Columbus Ohio Monday
Denver Colorado Wednesday

To:

St Louis Missouri Tuesday
Columbus Ohio Monday
Denver Colorado Wednesday
 
No.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Yes - maybe. Depends on what you do. If it is a query result, it should be
possible to pre-format each individual result string with right-filled spaces
to a predetermined length (e.g. 30, 20, and 10) and then concatenate the
three into one single string to be fed into the drop-down form; then enforce
a non-proportional font and you have exactly what you want to accomplish.
 
Would I count the charaters first, subtract from a set value then add
charaters on the right?

If so which string function(s) would I use?

Thanks again!


"obviously not very knowledgeable"
 
Back
Top