Hello all!
I have been working on a report in Access 2010 and I am running into a few issues that I can not seem to resolve. I have come up with work arounds for some of them, but it would be great if there was a cleaner way.
1) When I combine parts of the report, I lose the ability to format it. For example in a textbox, ="My favorite number is " & [TxtFavoriteNumber] works great. It displays the text and the number that is in the TxtFavoriteNumber textbox; however, if it is a decimal, it displays the full thing, even if I have it formatted to 2 decimal places in the TxtFavoriteNumber textbox. Is there some way that I can handle formatting within this combined textbox?
2) I can not seem to figure out how to change the order of the x-axis on a bar graph in a report. The bar graph is based on a query. Is the only way to order the x-axis of the bar graph to sort the query?
3) My computer is not the fastest thing created. I have a bunch of calculations and queries on a single report. When I am in layout view, access constantly keeps refreshing the formulas, queries, etc as I move things. In excel, there is a way to disable automatic refresh and use f9 to refresh manually. Is there a similar function in Access? If not, is there another way to "freeze" it?
Thank you for any help you can provide!