Can't format to currency.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
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.)
 
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.


Allen Browne said:
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.

Frank Martin said:
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
 
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

Frank Martin said:
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.


Allen Browne said:
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.

Frank Martin said:
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
 
Back
Top