Web Development

Ask something
Discussion Locked

Access2000 Report challenge

0 helpful
5 replies

by irenecm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a report that contains about 100 fields populated by control source properties. It was necessary to rename some controls and forms. How can I update the report control source properties without doing each one individually?

5 replies

by john_wills

I have a feeling I ought to be able to help, but I cannot envisage what is being asked. Do you have several fields on your form for each property? When you say "update" do you mean update your project or update the data within the database, and in the reports, for a particular version of your project?

by bob sellman

You can change common properties in report design mode by clicking the first control, then hold the shift key down while clicking on all other controls for which the properties will be set to the same setting.

The properties dialog box will then only let you change or set the properties that are common to all selected controls.

Or...if there is a logical numbering of the controls that need changing, then you could write some one time use code. Something that would be a for x = 1 to 100, next x situation. This would work if your controls are in a sequential naming situation (control1, control2, control3, etc.), so that you could build the reference to the control by combining the text ("control") with a string from the value of x. This would also mean that any changing references (to fields, for example) would have to follow the same sequential naming. You probably didn't do that so I won't discuss it any further. Wanted to mention it "just in case".

Another idea: if thefields have changed names, create or modify the query used as the data source of the report so the "old" names for the fields are set up in the query (using a format in the query builder like OldName: NewName).

If these don't give you ideas of how to solve your problem, you'll need to provide more information in your question.

Otherwise, I think you have to do like the rest of us and slog through it to complete the design of the report.

by irenecm

I know about the shift key down - good idea but there was a slightly different character in each box so that field was empty for mass substitution. The text boxes used data from a function and a form and incremented across. The form name is what Ineeded to change as his naming conventions were a bit unusual, like cmb for command button and textbox55. I was supposed to standardize the naming. When we realized we couldn't we just decided to leave well enough alone. thanks anyway.

This discussion is closed to new replies.