> Hello,
>
[quoted text clipped - 21 lines]
> I tried to put "CCur" after "SELECT" but nothing happened. Can someone
> help?
Please check in the design of table Pricing and make sure that the *Data
Type* -- not just the Format property -- of the Price field is Currency.

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
Studebaker - 23 May 2008 00:03 GMT
Dirk wrote:
"Please check in the design of table Pricing and make sure that the *Data
Type* -- not just the Format property -- of the Price field is Currency."
Hello Dirk,
I tried what you said and unfortunately it didn't work. I did forget to set
the format property to currency, though.
Thank you for your input, though.
> > Hello,
> >
[quoted text clipped - 24 lines]
> Please check in the design of table Pricing and make sure that the *Data
> Type* -- not just the Format property -- of the Price field is Currency.
In your row source Query include the Field you want to store, as usual, but
with a column width of zero, but use it as the Bound Column, and add a field
with Fmtd: Format([Price],"Currency") with a column width wide enough to
show it, then the field for description. By the way, "Description" is an
Access reserved word and, thus, not good to use as a field name. The name of
the calculated column is immaterial as it is only displayed for selecting,
not used anywhere else.
Formatting is not applied in displaying the selection list, so you have to
create the text output from the format ahead of time (in the query itself).
Interestingly, in my 15 years of using Access, I've had relatively few cases
of currency in a combo box, had never used this trick, and had never had a
complaint from a user about the unformatted price. But, there are always
learning opportunities, and I'll use it next time! Thanks for the learning
opportunity (or at least a reminder that the formatted currency value is
more obvious than just the number).
Larry Linson
Microsoft Office Access MVP
Studebaker - 23 May 2008 00:15 GMT
Hello Larry,
Can you explain something:
"In your row source Query include the Field you want to store, as usual,"
My Row Source says this so I got that part:
SELECT Pricing.Price, Pricing.Description FROM Pricing ORDER BY
Pricing.Price;
"but with a column width of zero"
I can't make it column width zero b/c it makes the combo box not show
anything. I have two columns so I put 0.00";0.00"
"and add a field with Fmtd: Format([Price],"Currency") with a column width
wide enough to show it, then the field for description."
This is where I get lost. I'm just learning this stuff so do I add the field
to the form and, if so, under what property do I put Fmtd:
Format([Price],"Currency")?
Also, I have the column count be "2" and then adjust the column wideth wide
enough to show the values in the drop down box, right?
Can you clarify?
Thank you very much for your help.
> In your row source Query include the Field you want to store, as usual, but
> with a column width of zero, but use it as the Bound Column, and add a field
[quoted text clipped - 16 lines]
> Larry Linson
> Microsoft Office Access MVP
John W. Vinson - 23 May 2008 01:36 GMT
>Hello Larry,
>
[quoted text clipped - 20 lines]
>
>Can you clarify?
PMFJI but what Larry was suggesting is to change the Rowsource query to
SELECT Pricing.Price, Format([Pricing].[Price], "Currency") AS ShowPrice,
Pricing.Description FROM Pricing ORDER BY Pricing.Price;
You'll also need to change the ColumnCount from 2 to 3, and change the
ColumnWidths to show three numbers - e.g.
0";0.5";2.5"
to conceal the unformatted number (10.5 say); display the same value formatted
as currency ($10.50); and display the description only when the combo is
dropped down, in the third column.

Signature
John W. Vinson [MVP]
Studebaker - 24 May 2008 17:26 GMT
Thank you very much!!! I haven't tried it out yet but I understand what he
was saying now.
I appreciate you stepping in to help!!
> >Hello Larry,
> >
[quoted text clipped - 34 lines]
> as currency ($10.50); and display the description only when the combo is
> dropped down, in the third column.