amount field not showing currency format

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

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


"babs" wrote in message
...
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

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 [MVP]" wrote:

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" wrote in message
...
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



.

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

babs wrote:
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 [MVP]" wrote:

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" wrote in message
...
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


.