Search results

NOt entirely sure I understand what you mean, but it gets me no further to knowing whether there is any quicker way to edit bits of report. I have done it manually in the time waiting for any help now. This is the kind of thing I have in Control Source of text boxes...

Is it possible to use find and replace to modify text in report design - or else is there something else I can do to get the same effect? I have a really useful report and I want to modify it for use with a different dataset. To do that I will need to change the text in over 150 text boxes. I...

I had not realised round worked like that - thanks.

Is there nothing simpler that would work? Most numbers come out OK when running a query e.g. I am happy with anything that is a whole number or has 1 or 2 D.Ps e.g. 100 or 100.5 or 100.25 are all fine. But Access does not seem to like displaying something like 100.333333333.... instead of doing...

I want to print the results of a query where some values are whole numbers, some have 1 decimal place, some have 0.3333333 recurring etc. Problem is that in order to fit all the columns on a page the column width does not allow all the 0.33333... to display. So what I see is like this (there are...