parsing text in a field

P

Paulb9

I have a form that among other things has three memo fields containing
fairly standardized reports. Using the OnCurrent Prop of the form I want to
parse each of these reports looking for very specific text strings. For
example:
If memo-field1 contains string1 and string2 and string3 and string4 set
background color to green, else set to red. Is the LIKE function the best
tool for this job?
 
J

Jonathan Parminter

Paul said:
-----Original Message-----
I have a form that among other things has three memo fields containing
fairly standardized reports. Using the OnCurrent Prop of the form I want to
parse each of these reports looking for very specific text strings. For
example:
If memo-field1 contains string1 and string2 and string3 and string4 set
background color to green, else set to red. Is the LIKE function the best
tool for this job?
Click to expand...

Hi Paul, use online help for information on the functions:
InStr()
Mid()
Left()
Right()
Len()

Luck
Jonathan
 
P

Paulb9

While the reports are fairly standardized, they are not exact. Cannot know
exactly ahead of time where the text will appear.
 
J

John Vinson

While the reports are fairly standardized, they are not exact. Cannot know
exactly ahead of time where the text will appear.
Click to expand...

The InStr() function will return the position of the text. For
instance the expression

If InStr("string1", [memofield]) > 1

will be True if "string1" appears anywhere within the memo field.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
P

Paulb9

Cool, thanks!
John Vinson said:
While the reports are fairly standardized, they are not exact. Cannot know
exactly ahead of time where the text will appear.
Click to expand...

The InStr() function will return the position of the text. For
instance the expression

If InStr("string1", [memofield]) > 1

will be True if "string1" appears anywhere within the memo field.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADDING values from one listbox to another on same form 1
Spliting up a field 1
Button to insert boilerplate text into field in a parent form 9
color coding values 0
Change text box background color depending on value in Label Reports 0
parse string to multi records 2
Filters: multi-criteria cells ? 3
Help parsing HTML into text in my text box within my form 4

Top