By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Textbox trubles

MGrowneyARSI
P: 90
Hello I have a text box That I would like to display both text and variables in I'm puting this code in the control source but I can quite seem to get it to work the two variables are public and set = to dlookups and work fine but the textbox kepps getting errors
="Please select between " & [MinVar] & " - " & [MaxVar] & " peers to administer your 360 surveys."
I'm sure I missing something simple here any help is more then welcome
TIA
Sep 17 '07 #1
Share this Question
Share on Google+
4 Replies


FishVal
Expert 2.5K+
P: 2,653
Hello I have a text box That I would like to display both text and variables in I'm puting this code in the control source but I can quite seem to get it to work the two variables are public and set = to dlookups and work fine but the textbox kepps getting errors
="Please select between " & [MinVar] & " - " & [MaxVar] & " peers to administer your 360 surveys."
I'm sure I missing something simple here any help is more then welcome
TIA
Hi, there.

I'm not sure Access allows to include variables even global one in ControlSource expression. You may need to write global function returning that global variable. LOL.
Sep 17 '07 #2

MGrowneyARSI
P: 90
That would explain why the code works in a MSGBox but not the textbox I'll give it a try.
Sep 17 '07 #3

MGrowneyARSI
P: 90
Well in the end I just set the textbox = text var1 - var2 text in the on open event works great now, what was my boss talking about LOL thanks for the help seems you were right can't do it in the Control Source thanks for pointing me in the right direction unlike my boss.
Sep 17 '07 #4

FishVal
Expert 2.5K+
P: 2,653
You are welcome.

Regards,
Fish
Sep 17 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.