format number as percent in text when it is one already
Posted on 2012-03-14
I am working on a report the has about 75 percent fields in it. The data type in number (double) so using the existing "percent" format changes "50" to "5000.0%". All I need it to do is added the percent symbol to make it "50%". I'm working in textboxes in a report. How can I do this using the format property?
I've got to many fields to do an update query. I could use controlsource = FieldName & "%", but that would require renaming all the text boxes as they have the same name as the field and that formula would cause a circular reference.
Please don't post the first thing the comes up from google.