A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

text boxes



 
 
Thread Tools Display Modes
  #1  
Old January 9th, 2008, 04:24 PM posted to microsoft.public.access.forms
DJACKSON
external usenet poster
 
Posts: 12
Default text boxes

I have a unbound text box on a form that's not in a query how do i bind that
to a report?
  #2  
Old January 9th, 2008, 05:07 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default text boxes

Can't be done.
Tell use what you want to do and perhaps we can tell you how.
--
Dave Hargis, Microsoft Access MVP


"DJACKSON" wrote:

I have a unbound text box on a form that's not in a query how do i bind that
to a report?

  #3  
Old January 9th, 2008, 05:28 PM posted to microsoft.public.access.forms
DJACKSON
external usenet poster
 
Posts: 12
Default text boxes

I have a label sticker report based on a select query and I would like to add
text to the sticker. The add text would change constantly so I would like to
enter that on a form through a text box. Is there any hope? Thanks for your
help

"Klatuu" wrote:

Can't be done.
Tell use what you want to do and perhaps we can tell you how.
--
Dave Hargis, Microsoft Access MVP


"DJACKSON" wrote:

I have a unbound text box on a form that's not in a query how do i bind that
to a report?

  #4  
Old January 9th, 2008, 05:34 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default text boxes

If all you're trying to do is copy text from the form onto the report, try
setting the ControlSource on the report to

=Forms![NameOfForm]![NameOfUnboundControl]

(complete with equal sign)

Note that the report won't work properly if the form isn't opened first.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"DJACKSON" wrote in message
...
I have a label sticker report based on a select query and I would like to
add
text to the sticker. The add text would change constantly so I would like
to
enter that on a form through a text box. Is there any hope? Thanks for
your
help

"Klatuu" wrote:

Can't be done.
Tell use what you want to do and perhaps we can tell you how.
--
Dave Hargis, Microsoft Access MVP


"DJACKSON" wrote:

I have a unbound text box on a form that's not in a query how do i bind
that
to a report?



  #5  
Old January 9th, 2008, 05:37 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default text boxes

On Wed, 9 Jan 2008 08:28:01 -0800, DJACKSON wrote:

I have a label sticker report based on a select query and I would like to add
text to the sticker. The add text would change constantly so I would like to
enter that on a form through a text box. Is there any hope? Thanks for your
help

"Klatuu" wrote:

Can't be done.
Tell use what you want to do and perhaps we can tell you how.
--
Dave Hargis, Microsoft Access MVP

"DJACKSON" wrote:

I have a unbound text box on a form that's not in a query how do i bind that
to a report?


It's still not clear (at least to me) exactly what you are attempting
to do with the value in the form's text box, but:
You could refer to the form control from the report, i.e.

=Forms!FormName!ControlName

The Form must be open when the report is run.
--
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #6  
Old January 9th, 2008, 05:38 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default text boxes

If you are on version 2003, you can use the OpenArgs argument of the
OpenReport method to pass the value of the text box to the report; otherwise,
you will have to do it from the Open event of the report.

If using the OpenArgs, you still use the Open event of the report.

If Not IsNull(Me.OpenArgs) Then
Me.lblMessage = Me.OpenArgs
End If

If you do it from the report

Me.lblMessage = Forms!MyFormName!MyTextBoxName

--
Dave Hargis, Microsoft Access MVP


"DJACKSON" wrote:

I have a label sticker report based on a select query and I would like to add
text to the sticker. The add text would change constantly so I would like to
enter that on a form through a text box. Is there any hope? Thanks for your
help

"Klatuu" wrote:

Can't be done.
Tell use what you want to do and perhaps we can tell you how.
--
Dave Hargis, Microsoft Access MVP


"DJACKSON" wrote:

I have a unbound text box on a form that's not in a query how do i bind that
to a report?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.