Hello, everyone,

Have a Microsoft Access 2003 form with a combo box used as a record
selector. The combo box "Row Source" is a table field containing SSN.
Setting the combo box format to @@@-@@-@@@@ displays them in the
standard xxx-xx-xxxx format, however, the combo box's drop dow list
shows only a list of unformatted 9 digit strings, which is a tad more
difficult to read. Is there a way to apply formatting to the contents
of the combo box drop down list?

Thanks

Arsene (AT) selenium (DOT) net wrote:
Change the combo box's RowSource to a query that includes
the SSN and a calculated field that formats the SSN:
FormattedSSN: Format(SSN, "@@@-@@-@@@@")

Then set the combo box properties:
ColumnCount 2
BoundColumn 1
ColumnWidths 0;

This way the formatted SSN wil be displayed in the drop
list, but the unformatted SSN will be the combo box's value
so you can use it to search for matching recods.

--
Marsh

On Wed, 16 Mar 2011 23:04:20 -0500, Marshall Barton
<marshbarton (AT) wowway (DOT) com> wrote:

You are indeed the man, Marshall.

Thanks !!!!!!