Search results

I have a 2003 Access report that is based on one query. The query has a calculated percentage that I want to display in the report. The user can choose the number of decimal places on a form that they want the percentage to round to in other calculations that are based on that percentage. I...

Hello, I have VBA code that looks at the first line in my report and reformats the text to include a dollar sign. I would now like to make the dollar sign to appear the same distance from the right of the cell, no matter how many digits the number has. I was trying to do a formula to...

I am trying to format the first row of my report as currency (see custom format below), and keep the rest as standard. I found the below code to change one field (Est Contract), but does anyone know how can I change all fields on the report at once? If CurrentRecord = 1 Then Me![Est...

I am trying to get the access report to change the number of decimal places based on the user input on a form. The only two choices I want are 0 and 2 decimal places in a percentage taken from a query. I have the query linked to the form to change automatically, but can't get the report to...