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

On Sun, 31 Dec 2006 20:44:00 -0800, Quin
<(E-Mail Removed)> wrote:

>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]

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

"Quin" <(E-Mail Removed)> wrote in message
news:FC0B7122-65D3-4D23-BB77-(E-Mail Removed)...
>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" wrote:

> On Sun, 31 Dec 2006 20:44:00 -0800, Quin
> <(E-Mail Removed)> wrote:
>
> >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]
> 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"

"Larry Linson" wrote:

> 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
>
> "Quin" <(E-Mail Removed)> wrote in message
> news:FC0B7122-65D3-4D23-BB77-(E-Mail Removed)...
> >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
>
>
> Larry, thanks for your comments. I found them helpful

Quin