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 » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Variable in textbox/label



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2005, 12:23 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Variable in textbox/label

I need to make a report to send car brochure's out from Access. In the main
body of the letter the model of the car is used several times. Is it possible
to have this included in the mass of text like you would in VB code ie:
"Here is your brochure for a " & CarModel & "."
or is there some way to put another lable over an existing one so that it
prints with the correct spacing?
--
Adam Thwaites
Access Database Designer
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)
  #2  
Old November 22nd, 2005, 01:39 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Variable in textbox/label

You can use a text box on your report with a control source like:
="Here is your brochure for a " & CarModel & "."

--
Duane Hookom
MS Access MVP


"Adam Thwaites" wrote in message
...
I need to make a report to send car brochure's out from Access. In the main
body of the letter the model of the car is used several times. Is it
possible
to have this included in the mass of text like you would in VB code ie:
"Here is your brochure for a " & CarModel & "."
or is there some way to put another lable over an existing one so that it
prints with the correct spacing?
--
Adam Thwaites
Access Database Designer
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing Variable HELP HELP HELP Hansford cornett New Users 6 August 15th, 2005 05:23 PM
DAP DAP DAP...Who is the expert here? vrk1 General Discussion 12 August 12th, 2005 03:13 PM
Passing Variable Name to a Function Bob Howard Using Forms 1 June 28th, 2005 04:00 PM
variable defined as double - having trouble! jenn General Discussion 13 December 15th, 2004 04:22 PM


All times are GMT +1. The time now is 07:34 PM.


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