If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
amount field not showing currency format
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 |
#3
|
|||
|
|||
amount field not showing currency format
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 . |
#4
|
|||
|
|||
amount field not showing currency format
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 . |
Thread Tools | |
Display Modes | |
|
|