jeanne said:No, This is a text box in specific report - not a form-
For instance in the header od a report you can have a text box and in the
unbound portion as the control source [enter month and year] so when the user
enters November 2004 the report header reads for the month of November 2004.
This is the same context but instead the user is entering a number that I
want formatted as currency.
I have tried the help and it did not give me the answer
Martin J said:I assume u mean that you have a text box in a form where the user puts in an
amount in a text box that has a currency format. The format is only for that
text box. In the report text box you need to change format to currency if it
is a number field. If it is a text field you might have to use $##.## in
format. Use the help F1 for more info regarding format.
HTH
Martin J
Martin J said:In the report text box (showing the number) properties you need to change
format to currency if it is a number field. If it is a text field you might
have to use $##.## in format. press f1 while cursor is in the format property
to get help.
HTH
Martin J
P.S. here's a copy of the help in acc2000
...
Symbol Description
. (period) Decimal separator. Separators are set by double-clicking Regional
Settings in Windows Control Panel.
, (comma) Thousand separator.
0 Digit placeholder. Display a digit or 0.
# Digit placeholder. Display a digit or nothing.
$ Display the literal character "$".
% Percentage. The value is multiplied by 100 and a percent sign is appended
...
jeanne said:No, This is a text box in specific report - not a form-
For instance in the header od a report you can have a text box and in the
unbound portion as the control source [enter month and year] so when the user
enters November 2004 the report header reads for the month of November 2004.
This is the same context but instead the user is entering a number that I
want formatted as currency.
I have tried the help and it did not give me the answer
Martin J said:I assume u mean that you have a text box in a form where the user puts in an
amount in a text box that has a currency format. The format is only for that
text box. In the report text box you need to change format to currency if it
is a number field. If it is a text field you might have to use $##.## in
format. Use the help F1 for more info regarding format.
HTH
Martin J
:
I have a text box in a report where the user will enter the information. I
set the formatting at currency but when the user enters the value it doesn't
show on the report as currency.... Any help?
jeanne said:Setting the format properties to either does not work.
Here is the format page for Text Box: Text 11 on my 4600 flash
name: Text 11
control source: [enter current balance]
format: currency
decimal places: auto
the user enters 2120.23
on the report I want the number to show as $2,120.23
currently it just comes back as 2120.23
Any help?
Martin J said:In the report text box (showing the number) properties you need to change
format to currency if it is a number field. If it is a text field you might
have to use $##.## in format. press f1 while cursor is in the format property
to get help.
HTH
Martin J
P.S. here's a copy of the help in acc2000
...
Symbol Description
. (period) Decimal separator. Separators are set by double-clicking Regional
Settings in Windows Control Panel.
, (comma) Thousand separator.
0 Digit placeholder. Display a digit or 0.
# Digit placeholder. Display a digit or nothing.
$ Display the literal character "$".
% Percentage. The value is multiplied by 100 and a percent sign is appended
...
jeanne said:No, This is a text box in specific report - not a form-
For instance in the header od a report you can have a text box and in the
unbound portion as the control source [enter month and year] so when the user
enters November 2004 the report header reads for the month of November 2004.
This is the same context but instead the user is entering a number that I
want formatted as currency.
I have tried the help and it did not give me the answer
:
I assume u mean that you have a text box in a form where the user puts in an
amount in a text box that has a currency format. The format is only for that
text box. In the report text box you need to change format to currency if it
is a number field. If it is a text field you might have to use $##.## in
format. Use the help F1 for more info regarding format.
HTH
Martin J
:
I have a text box in a report where the user will enter the information. I
set the formatting at currency but when the user enters the value it doesn't
show on the report as currency.... Any help?