Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting a space in an expression 1

Status
Not open for further replies.

luisog

Technical User
Apr 24, 2003
10
MX
I'm trying to extract a value from an Access for, but I named the form with two words like "First Register", then when I try to introduce the expression
Forms!First Register!... Visual does not let me because I have a space in the expression, the I try with Forms!First_register!... but the program says that the form does not exists. I want to know if there is a way to introduce the space value or if I have to change the name of the form to make it work. Thanks
 
Forms![First Register![Control Name]

Square brackets do the trick in Access...

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com
 
Thank you very much, It work perfect.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top