Using Controls in a Report

  • Thread starter Thread starter Michael J. Strickland
  • Start date Start date
M

Michael J. Strickland

Anyone know how to use a control in a report to enter data before the report is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text box shows up on the report in "Print Preview" screen, but I can't access it to enter data. Also this is too late - the report has already been formatted.

Thanks in advance for any help.


--
 
Why do you not want to use an input box. Is there a better way?

--
Duane Hookom
MS Access MVP


Anyone know how to use a control in a report to enter data before the report
is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report
that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text
box shows up on the report in "Print Preview" screen, but I can't access it
to enter data. Also this is too late - the report has already been
formatted.

Thanks in advance for any help.


--
 
Actually, I want to allow the user to input a date (using the DateTime Picker) but the same problem applies to trying to use a text box.

The whole point is I want the simple, point & click, constrained input of a control as opposed to the Input Box's text input.

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Why do you not want to use an input box. Is there a better way?

--
Duane Hookom
MS Access MVP


Anyone know how to use a control in a report to enter data before the report
is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report
that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text
box shows up on the report in "Print Preview" screen, but I can't access it
to enter data. Also this is too late - the report has already been
formatted.

Thanks in advance for any help.


--
 
Then, use a form with a control or two to enter/select a date value that
will show in your report.

--
Duane Hookom
MS Access MVP


Actually, I want to allow the user to input a date (using the DateTime
Picker) but the same problem applies to trying to use a text box.

The whole point is I want the simple, point & click, constrained input of a
control as opposed to the Input Box's text input.

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Why do you not want to use an input box. Is there a better way?

--
Duane Hookom
MS Access MVP


Anyone know how to use a control in a report to enter data before the report
is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report
that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text
box shows up on the report in "Print Preview" screen, but I can't access it
to enter data. Also this is too late - the report has already been
formatted.

Thanks in advance for any help.


--
 
Michael said:
*Anyone know how to use a control in a report to enter data befor
the report is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alon
report that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), th
text box shows up on the report in "Print Preview" screen, but
can't access it to enter data. Also this is too late - the report ha
already been formatted.

Thanks in advance for any help.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
--------------------------------------------------------------- *
Click to expand...
My preferred way is to create a VB-event on opening the report an
having there the InputBox statement, which allows you to enter data
etc.

This InputBox is shown before the report is opened and formatted.

hope this helps you further..


-
Herman Janse
 
I want a single stand-alone module (report) not two
modules (report & from) that I will have to keep together.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Then, use a form with a control or two to enter/select a date value that
will show in your report.

--
Duane Hookom
MS Access MVP


Actually, I want to allow the user to input a date (using the DateTime
Picker) but the same problem applies to trying to use a text box.

The whole point is I want the simple, point & click, constrained input of a
control as opposed to the Input Box's text input.

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Why do you not want to use an input box. Is there a better way?

--
Duane Hookom
MS Access MVP


Anyone know how to use a control in a report to enter data before the report
is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report
that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text
box shows up on the report in "Print Preview" screen, but I can't access it
to enter data. Also this is too late - the report has already been
formatted.

Thanks in advance for any help.


--
 
I don't want to use an Input Box, I want to use a control.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
*Anyone know how to use a control in a report to enter data before
the report is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone
report that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the
text box shows up on the report in "Print Preview" screen, but I
can't access it to enter data. Also this is too late - the report has
already been formatted.

Thanks in advance for any help.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
--------------------------------------------------------------- *
Click to expand...
My preferred way is to create a VB-event on opening the report and
having there the InputBox statement, which allows you to enter data,
etc.

This InputBox is shown before the report is opened and formatted.

hope this helps you further...
 
If you want to use "constrained input" then you will have to use a control
on a form. If you can get by without constrained input, then set the control
source of a text box to something like:
=[Enter some value]

--
Duane Hookom
MS Access MVP
--

I want a single stand-alone module (report) not two
modules (report & from) that I will have to keep together.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Then, use a form with a control or two to enter/select a date value that
will show in your report.

--
Duane Hookom
MS Access MVP


Actually, I want to allow the user to input a date (using the DateTime
Picker) but the same problem applies to trying to use a text box.

The whole point is I want the simple, point & click, constrained input of a
control as opposed to the Input Box's text input.

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Why do you not want to use an input box. Is there a better way?

--
Duane Hookom
MS Access MVP


Anyone know how to use a control in a report to enter data before the report
is printed?

I want to put a text box on a report and use it to
enter a value which will then be used to format the report.

I don't want to use a form to hold the text box. I want a stand-alone report
that will allow me to input data from a text box.
I also don't want to use an InputBox to get the data.

When I put a text box in the report (Header or Detail sections), the text
box shows up on the report in "Print Preview" screen, but I can't access it
to enter data. Also this is too late - the report has already been
formatted.

Thanks in advance for any help.


--
 
Back
Top