Can't format to currency.

[Frank Martin]

I have Access2000 with WindowsXP.

I am redesigning my invoice form and in the InvoiceLines subform I use the
expression, (for example) " ProductID.Column(2)" which selects the specific
current customer price for the invoice lines. But I can't get this
"ItemPrice" to format to currency even though the properties has been set to
this. The underlying queries fields have been set too to no avail. Please
help Frank

 

[Allen Browne]

Try typecasting so Access knows it's not a string value:
CCur([ProductID].[Column](2))

You are aware that this refers to the 3rd column of the combo? (The first
column is zero.)

 

[Frank Martin]

Thank you, I'll try this. I have found out about combos mainly thru trial
and error, but now there're playing up again because when I try to change
the properties from the main view (opposed to design view) the alterations
such as combo column dimensions and combo width, these changes do not stick.

Try typecasting so Access knows it's not a string value:
CCur([ProductID].[Column](2))

You are aware that this refers to the 3rd column of the combo? (The first
column is zero.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have Access2000 with WindowsXP.

I am redesigning my invoice form and in the InvoiceLines subform I use the
expression, (for example) " ProductID.Column(2)" which selects the
specific
current customer price for the invoice lines. But I can't get this
"ItemPrice" to format to currency even though the properties has been set
to
this. The underlying queries fields have been set too to no avail.
Please
help Frank

 

[AlCamp]

Frank,
Have you tried formatting in the query column itself...
ex. FormattedField : Val(Format(ProductID, "$#,###.00"))

I think when you format a query column using the column "property box",
it only "sticks" if the query is a "saved" query.
hth
Al Camp

Thank you, I'll try this. I have found out about combos mainly thru trial
and error, but now there're playing up again because when I try to change
the properties from the main view (opposed to design view) the alterations
such as combo column dimensions and combo width, these changes do not
stick.

Try typecasting so Access knows it's not a string value:
CCur([ProductID].[Column](2))

You are aware that this refers to the 3rd column of the combo? (The first
column is zero.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have Access2000 with WindowsXP.

I am redesigning my invoice form and in the InvoiceLines subform I use the
expression, (for example) " ProductID.Column(2)" which selects the
specific
current customer price for the invoice lines. But I can't get this
"ItemPrice" to format to currency even though the properties has been set
to
this. The underlying queries fields have been set too to no avail.
Please
help Frank