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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event Procedure in Microsoft Access 1

Status
Not open for further replies.

songreg

Programmer
Aug 5, 2002
2
US
How can I continue typing my codes in one line to not to be able to get an error for exceeding 255 characters.

I am using a very long field names and table title.
I tried making them smaller but still quite a few of them. Please help me figure out the code on how to continue your codes on the next line without getting an error.
 
It's simple really - when you get to the point where you need to move to a new line, put a space, then underscore, then hit enter key to continue on next line- Access ignores the line change. eg

this is my first chunk of code and _
this is my second

gets treated as if it were all one line.

Hope this helps

Nigel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top