List Box Format

  • Thread starter Thread starter Clint Liezert
  • Start date Start date
C

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 "@@-@@@@@.@@@"
 
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
________________________
 
Back
Top