List Box Format

[Clint Liezert]

Can I control the format of columns in a "multiple
select" list box? My data consists of a string of 10
characters. In some cases I would like it displayed
as "@@-@@@-@@-@@@" and in other cases I would prefer it
to be "@@-@@@@@.@@@"

 

[Gary Miller]

Clint,

You can do the formatting in a query and base the list box
on the query or you can use the format function directly in
a SQL statement for your RowSource....

SELECT Format([YourFieldName],"@@-@@@-@@-@@@") AS x
FROM tblYourTable;

You may have some problems if you are using this field as a
criteria to find a record or if you are storing the output
and will need to link it to the original format, so you may
want to have a hidden bound first column that doesn't have
the formatting if this is the case.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Albert D. Kallal]

You can always built some sql that uses the format commend (this was suggest
by Gary in this thread).

Another nice solution is to simply use a continues form in place of the list
box.

Here is some screen shots of what I mean:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm