472,119 Members | 1,623 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

How Do I highlight a string and get the focus into a record on my form

222 100+
Please help me

Using access 2003

I do have a form (continuous) that expand for me all products in a table name "[products]

I made a [textbox] in this form and it is unbounded

What i need is a botton that on click i want to find any part of the field where the [textbox]= [fieldname]---> get the focus on it and highlight it

I'm using this code that i found on this website

Application.Echo False
DoCmd.FindRecord textbox
Application.Echo True

this code works if the form is set to single form ..isn't wroking on the continuous form is there any other method??
Aug 21 '07 #1
2 1555
1,206 Expert 1GB
Hi, I'm a little confused.

Do you want the user to be able type something into the textbox and find a match for any field on the form or a specific field?

Once found what exactly do you want done? Do you want the entire row selected? Or just have the record selector pointing to the record?
Aug 23 '07 #2
222 100+
Yes I want to highlight the string that i'm searching and has the focus on the record .... any idea about that ...

It is the same of the access search (using any part of the field)...

Am i able to see the code of the search that access use or there is another method...

thank you for ur reply ....
Aug 23 '07 #3

Post your reply

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

Similar topics

17 posts views Thread by Neil Ginsberg | last post: by
4 posts views Thread by Andrew Poulos | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.