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

Problems searching/finding long strings

P: 1
I'm using Access 2007 and I have a table with a couple of regular expressions. I need to search this table to find if a newly created regular expression already exists in this table.

For short regular expressions, the SQL query I wrote can find them, but for really long regular expressions the query doesn't seem to recognize them. When I go into the table and copy the long regular expression and then click ctrl+F, even this cannot find the regular expression I just copied.

Is there a problem in Access where strings that are longer than a certain length are "invisible"?

This is a sample regular expression that neither the SQL query nor simply clicking ctrl+F cannot find:

[-A-Za-z0-9\040!#$%&'+;=@[\\\]^_`{}~(),.]{64}|[-A-Za-z0-9\040!#$%&'+;=@[\\\]^_`{}~(),.]{1,63}\177

When I do this in other applications (like Excel) I have no problem finding the long string via ctrl+F.
Apr 19 '10 #1
Share this Question
Share on Google+
1 Reply


patjones
Expert 100+
P: 931
Regular text fields in Access can be up to 255 characters long. I would check the length of the expressions in question, and what the size of the fields are set to in Table Design view.

Something else to be careful of is having the character ' in the string. A SQL query may not pick up on the string correctly because the ' character modifies the structure of the query's WHERE clause. I'm not sure whether having this character in the string will affect the use of Ctrl+F.

Pat
Apr 19 '10 #2

Post your reply

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