list box

[srideout2525]

how can i format a phone number value in a list box? i have a listing of information and one piece of the information set is a phone number. i would like it to displayed formatted. Much like an input mask...!\(999") "000\-0000;;_

and suggestions?

 

[dcx693]

Can you format it using the rowsource properties? (by clicking the 3-dot thingee next to the Row Source property line and using either a formula or custom format to display it the way you want?)

 

[srideout2525]

I'm taking the values from a query and they all apppear in one list. so i can;t format one value in the list. i hope you understand what i mean.

 

[Mile-O]

Forma it in the query.

 

[pcEars]

Speaking for the simple minds...

Could you not simply choose to have the input mask save the data WITH the formatting? I believe it is an option in the wizard. (although I realize there's probably a good reason not to, which I hope I'll soon learn)

 

[srideout2525]

i can't seem to format IN the query. I guess I don;t know how.

As for saving the format ..you are right, I remember selecting against that option before, for a reason unknow to me right now, but i recall someone telling me in the past that it wasn;t a good practice.

 

[Mile-O]

NewField: Format([Fieldname], "(000) 000-0000")

OR

click on the field in query editor
select properties
change its format

 

[srideout2525]

Thanks alot. Simple minds here. It's been a long day