Listbox Formating, See Attachement

Matrix_zero

Registered User.
Local time
Today, 15:16
Joined
Jan 26, 2005
Messages
64
Ok, still some visual work to do on this screen, but what i want to do is format the 2nd and 3rd colum as currency. As you can see in the attachement it currentley doesn't show cents. Any help or suggestions how i can correct this would be appreciated.
 

Attachments

If the field is defined as currency in the table, the currency formatting appears in a list box. Access 2002.
 

Attachments

that doesn't help much

That works for that table, but i have my data stored in another file, i am also using the

me.listbox.additem (rs!something & ":" & rs!something2 & ":" & rs!something3)
top populate the listbox.

i could maybe set rs!something2 as a currency variable and insert it using
me.listbox.additem (rs!something & ":" (curency variabl) & ":" & rs!something3)

Edit : Nope, that didn't work either

Any thoughts?

The origional table in the other database is set to currency.
 
Last edited:
me.listbox.additem("$" & rst!dollarvaluefield)
 
Nope, that only makes 25.50 show up as $25.5, and it still makes 10.00 appear as $10
 

Users who are viewing this thread

Back
Top Bottom