Auto Updating Percent

[walter189]

Is there any way around having access auto percent your decimal numbers in a report. For instance i have a bunch of records that are going to have numbers that are between 0 and 1 but are actually percents at that small of a level. Ie i want the percent sign to show up but I dont want it to change 0.71 to 71% when i change the format to a percent. Does anyone know how to keep a decimal between 0 and 1 as a decimal but also a percent? I want 0.71 to become 0.71% essentially

[boblarson]

You could set your text box's CONTROL SOURCE to be:

=Format([FieldNameHere], "0.00") & "%"

But you need to make sure that the text box is not named the same as the field name. So if the field name was named SOMEFIELD then you make sure that the text box is named something else like txtSOMEFIELD.