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

Help With Delimiting Text

P: n/a
In one of my applications I need help delimiting text in the following
situation.

User needs to be able to enter things like LADDER 12' or BOLT 2" into a
text box on one of the forms. I have some code that needs to work with
the text box value on various events. Some of these events require a
DLookUp of the contents of the text box in one or more of the tables in
the application. When I code DLookUp("FieldName","[TableName]",
[OtherField] = '" & Me.TextBoxName.Value & "'") I (quite obviously) get
errors because of the single and or double quotes in the text box entry.
Can someone please help me out of the brain fart I am having and point
me in the right direction to accomplish the underlying objective to look
up the FieldName value in the TableName table?

Thanks,
DB
Aug 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try double quotes like
DLookUp("FieldName","[TableName]", [OtherField] = """ & Me.TextBoxName
& """")

Aug 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.