listbox item looses formatting

[JSDART!!]

I have a listbox with client DOB SS gender
the user picks a client and then opens the record.

the Query holds the format of the SS number but when opened in the listbox it looses its formating and all the numbers run together

any suggestions
thanks

 

[WayneRyan]

js,

A query column, textbox, table column can all have things like formats and
input masks for them.

But as far as I know, ListBoxes (and combos) don't allow you that degree of
control.

In the query that feeds your ListBox or Combo, you can explicitly format
the field using functions like CStr(), Mid(), Format(), InStr() etc.

Wayne