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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.