Combo Box Format

[Willy Wonka]

I have a combo box based on a query. If I look at the query, the resulting
currency field looks like a currency field. But when I pull down the combo
box in the form, that same field just looks like numbers. Anyone know how to
fix?

 

[Jacqueline]

You need to also set the form that contains the combo box property as
currency. The same goes for table fields. I have noticed that even though I
format table fields the formatting must also be set for the form, using the
property options for that field.
Hope this helps.

 

[Willy Wonka]

The problem is, the currency field is the fourth (out of 8) field on the drop
down list. Once I select the record, it fills in properly, but while I'm
searching through the choices dropped down, they are not currency. I hope I
am making sense...

 

[Jacqueline]

With your form open in design view do this:

select the combo box that you want to format as currency
either right click and select properties or click on properties in the menu
bar
Click on the format tab
Format should be one of the first drop down options in the list of items in
the list
Find currenancy and click on it to select
click out of the field and save
go to form view to test

Let me know if this does not work

 

[Willy Wonka]

That doesn't work. The bound field is not the currency field. The currency
field is just one of the eight fields displayed from the query...

 

[Ambyr via AccessMonster.com]

The number that you see instead of the currency, is it the ID or primary key
number for that record, or is it the currency amount unformatted?

The problem is, the currency field is the fourth (out of 8) field on the drop
down list. Once I select the record, it fills in properly, but while I'm
searching through the choices dropped down, they are not currency. I hope I
am making sense...

You need to also set the form that contains the combo box property as
currency. The same goes for table fields. I have noticed that even though I

[quoted text clipped - 6 lines]

 

[Jacqueline]

ok, I think we need to start over. The combo is what you are using to
populate a table field, right? But the data feeding the combo is coming from
a query?

Where does the query data come from?

Are you sure you build the combo correctly? Sometimes it is easier to delete
the combo box and rebuild it. I have done this many times, make sure you read
all the options and tell the combo to do what you need. like populate the
table based on the information you select in the combo.

If the data is formated as currency in the query I can't see why it would
not populate the combo as currency.

 

[Willy Wonka]

It is the correct currency amount, just unformatted.

The number that you see instead of the currency, is it the ID or primary key
number for that record, or is it the currency amount unformatted?

The problem is, the currency field is the fourth (out of 8) field on the drop
down list. Once I select the record, it fills in properly, but while I'm
searching through the choices dropped down, they are not currency. I hope I
am making sense...

You need to also set the form that contains the combo box property as
currency. The same goes for table fields. I have noticed that even though I

[quoted text clipped - 6 lines]

box in the form, that same field just looks like numbers. Anyone know how to
fix?

 

[John W. Vinson]

It is the correct currency amount, just unformatted.

Consider basing the combo on a query with a calculated field:

ShowAmount: Format([fieldname], "Currency")

Have this field with a nonzero width in the ColumnWidths, and include the
actual value with a zero width; this will let you display $25.31 but store
25.31.

 

[Willy Wonka]

and.......we have a WINNER! Thanks so much.

It is the correct currency amount, just unformatted.

Consider basing the combo on a query with a calculated field:

ShowAmount: Format([fieldname], "Currency")

Have this field with a nonzero width in the ColumnWidths, and include the
actual value with a zero width; this will let you display $25.31 but store
25.31.