Formating Textboxes

[desibabu90]

I am pushing data to textboxes from cascading combo boxes. The data is not formatted when it it in the combo box and I have set the textbox to be formatted (currency, general number, etc.) but the numbers still show up as "raw" data and not converted..

is there any way I can format the data when i am calling them out from the query to the combo box.

[alansidman]

Have you tried formatting the record source for the combo boxes?

[desibabu90]

the problem is that the record source is a locked table because the information is coming from an oracle database. I cannot change anything on that linked table and even though i have formated the data in a query (record source) it doesn't carry the format into the form.

[rpeare]

by pushing I'm assuming you mean the text boxes are unbound if so you can do something like

me.textbox = format([Fieldname], "Currency")
or
me.textbox = format([Fieldname], "General Number")

and it should work ( haven't tested in particular)

[desibabu90]

by pushing I'm assuming you mean the text boxes are unbound if so you can do something like

me.textbox = format([Fieldname], "Currency")
or
me.textbox = format([Fieldname], "General Number")

and it should work ( haven't tested in particular)

it didnt work for me...
let me know if I am doing something wrong:

I put that code in the After Update of the textbox.
changed "textbox" to the actual name of my textbox
changed "Fieldname" to the actual field name that is coming over from the record source.

[rpeare]

What type of form are you using, bound or unbound?

If it's bound you set the format in your query

FieldConverted: format(fieldname,"currency")

if it's unbound don't use the after update event, create the format as you're populating the data.

[desibabu90]

the form was not bound but now i bound it to a table with blank fields and was able to format the textboxes by using the fields in the table as control source.

thanks!