amount field not showing currency format

  • Thread starter Thread starter babs
  • Start date Start date
B

babs

I have set the control source for an AMOUNT text box equal to below

=Cbodisposition.Column(2)

when i click off the control source in the property of the text box
it puts brackets around the name of the dropdown box and looks like this
=[cbodisposition].[column](2)

It is returning what is in the 3rd column - column(2) for code purposes -
which is the award amount based on the disposition selected in the combo box
cbodisposition but it is not showing the currency formatting that is set the
the table for the dropdown,which is also set to currency in the form view of
the text box [Amount] it appears left aligned LIKe text and not showing the
currency formatting that it should????

what is wrong?
Thanks,
Barb
 
Set the Currency format in the Format property of the text box. If that
still isn't enough, change your expression to:

=CCur([cbodisposition].[column](2))
 
Yes - I did format the property of the text box - not showing

used the =CCur([cbodisposition].[column](2)) and get =error#

any more ideas?

thanks,
Barb
Arvin Meyer said:
Set the Currency format in the Format property of the text box. If that
still isn't enough, change your expression to:

=CCur([cbodisposition].[column](2))

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


babs said:
I have set the control source for an AMOUNT text box equal to below

=Cbodisposition.Column(2)

when i click off the control source in the property of the text box
it puts brackets around the name of the dropdown box and looks like this
=[cbodisposition].[column](2)

It is returning what is in the 3rd column - column(2) for code purposes -
which is the award amount based on the disposition selected in the combo
box
cbodisposition but it is not showing the currency formatting that is set
the
the table for the dropdown,which is also set to currency in the form view
of
the text box [Amount] it appears left aligned LIKe text and not showing
the
currency formatting that it should????

what is wrong?
Thanks,
Barb
Click to expand...


.
Click to expand...
 
CCur will fail if the value is not a number. Blank is not a number

Try

=CCur(Nz([cbodisposition].[column](2)))




John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Yes - I did format the property of the text box - not showing

used the =CCur([cbodisposition].[column](2)) and get =error#

any more ideas?

thanks,
Barb
Arvin Meyer said:
Set the Currency format in the Format property of the text box. If that
still isn't enough, change your expression to:

=CCur([cbodisposition].[column](2))

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


babs said:
I have set the control source for an AMOUNT text box equal to below

=Cbodisposition.Column(2)

when i click off the control source in the property of the text box
it puts brackets around the name of the dropdown box and looks like this
=[cbodisposition].[column](2)

It is returning what is in the 3rd column - column(2) for code purposes -
which is the award amount based on the disposition selected in the combo
box
cbodisposition but it is not showing the currency formatting that is set
the
the table for the dropdown,which is also set to currency in the form view
of
the text box [Amount] it appears left aligned LIKe text and not showing
the
currency formatting that it should????

what is wrong?
Thanks,
Barb
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top