Cut and Paste from Report to Form

[Guest]

I am learning Access...

This probably is not the "normal" way do doing things, but I created a table
and then I created a report. I then cut and pasted most of the controls from
the report into a new form.

The reason for doing this is I will then have exactly the same size text
boxes in the form as the report and I will know that if text entered into the
form does not fit it will not fit into the report. I can easily see when I
have typed too much text into the text boxes of the form.

Anyway, I can not seem to make my text show up in the report when it is
entered into the form text boxes. All the controls in the form and report
seem to have the "control source" established.

Is this copy and paste idea of mine ok?

Quin

 

[John Vinson]

I am learning Access...

This probably is not the "normal" way do doing things, but I created a table
and then I created a report. I then cut and pasted most of the controls from
the report into a new form.

The reason for doing this is I will then have exactly the same size text
boxes in the form as the report and I will know that if text entered into the
form does not fit it will not fit into the report. I can easily see when I
have typed too much text into the text boxes of the form.

Anyway, I can not seem to make my text show up in the report when it is
entered into the form text boxes. All the controls in the form and report
seem to have the "control source" established.

Is this copy and paste idea of mine ok?

Quin

Well, you also must set the Form's Recordsource to the same query or
table as the Reports.

Note that you can open a Form in design view and use File... Save As
to save it as a Report, or vice versa.

John W. Vinson[MVP]

 

[Larry Linson]

Did you set a RecordSource for the Form identical to the RecordSource of the
Report, to "bind" the Form to the data? Or, are you displaying the Report
prior to the Record being saved that's entered on the Form? I ask these
questions because there's no linkage between a Form and a Report, except via
the underlying Tables.

A record is saved when you explicitly Save with the menu item (Records |
Save Record) or Shift+Enter, or by moving off the record to another, or by
closing the Form.

It may not be particularly helpful to you now, but later you may appreciate
that many always create a Query, even if it is every field in just one
table, to use as RecordSource.

I've never done what you are doing, because I may want different
configurations of Controls on the Form and the Report. For example, there is
a CanGrow property on Controls in a Report that will expand the Control to
another line, if needed.

But, I see nothing wrong with what you're doing. Just be aware that when you
copy and paste Controls, you do NOT bring along event code or event macros.

Larry Linson
Microsoft Access MVP

 

[Guest]

Well, you also must set the Form's Recordsource to the same query or
table as the Reports.

Note that you can open a Form in design view and use File... Save As
to save it as a Report, or vice versa.

John W. Vinson[MVP]
My form and report is now working. I found that I can save a form as a report using "Save As" but I can not save a report as a form. The only options offered are "Report" and "Data Access Page"

 

[Guest]

Did you set a RecordSource for the Form identical to the RecordSource of the
Report, to "bind" the Form to the data? Or, are you displaying the Report
prior to the Record being saved that's entered on the Form? I ask these
questions because there's no linkage between a Form and a Report, except via
the underlying Tables.

A record is saved when you explicitly Save with the menu item (Records |
Save Record) or Shift+Enter, or by moving off the record to another, or by
closing the Form.

It may not be particularly helpful to you now, but later you may appreciate
that many always create a Query, even if it is every field in just one
table, to use as RecordSource.

I've never done what you are doing, because I may want different
configurations of Controls on the Form and the Report. For example, there is
a CanGrow property on Controls in a Report that will expand the Control to
another line, if needed.

But, I see nothing wrong with what you're doing. Just be aware that when you
copy and paste Controls, you do NOT bring along event code or event macros.

Larry Linson
Microsoft Access MVP




Larry, thanks for your comments. I found them helpful

Quin