Recent content by RCCOLA

I'm looking to get something like this done as well. Basically I'm looking for a text box to display a value (in this case "Empty) if the underlying query returns no results. I'm also looking at getting the associated labels to disappear. I've looked at Nz statements, IIF statements in the query...

Thank you. For now I just switched it to memo type. Now I know what to do though.

Thanks I'll give it a shot. I'm not Looking to format the entire field, just every time a specific set of words appear on the report. Thanks again.

I am fairly new to access and in particular VBA. So I've been working on setting up a spell checker for a specific memo field in a form using a button. Here is the code Private Sub Spellcheck_click() With Me!Description If Len(.value) >0 Then DoCmd.SetWarnings False .SetFocus...

Now, I don't want it to format in the actual memo field in the form. I would like to have it format it when I open the report for the selected record from the form. I have conditionally format the entire field if it recognizes the criteria I set but I can't conditionally format just part of that...

Thanks Pat, I will start doing some research on tags. I'm working with A2007 but for some weird reason I can not search for certain records when the boxes are in memo format and I need them to be in memo format for a search for I set up. I have to keep them in plain text. The way I have it...

Hello, I am attempting to condiotionally format certain text (not the entire field) within a memo field in a report. I have several values and each of the values need to be formatted either red, blue, or green. So For example I would like access 2007 to look for the following string of...

RCCOLA - New to Access but picking up quickly. Interested in VBA