Hi,

I've got a form that using check boxes to update a summary text box with information based on which check boxes have been checked.

However, if one is checked in error and then unchecked I would like to remove the text from the summary text field.

I've tried to use the Substitute the text with just a blank and all it seems to do is keep the text but put it in lower case. I had bullet points but then removed these to see if that would help but didn't

I'm not sure where to go from here. Ideally I would like to keep the bullets but if they need to go that fine.

Any help would be greatly appreciated.

TIA

 

 

 

From a quick glance, i noticed that your Substitute references $DeleteField and not $DeleteText. Try changing that since you specified $DeleteText in the second step.

Thanks school boy error. I fixed that. However, it still doesn't want to work.

The text within the variable isn't encased in quotes and the substitute needs it to be (tested it with the actual text ). HOw do I get the text to encase in quotes whilst using it in the Substitute string?

Escape the quotes with a backslash:

Substitute(YourField; "Some Text"; "\"" & $yourVariable & "\"")

Thank you. I've tried that but it doesn't want to work.

Substitute ( HoDObservations::Overall_Strengths ; "\"" & $DeleteText & "\"" ; "" )

this is the text in the box

A positive learning atmosphere is evident

Students’ pride in their work is evidenced through presentation and work rate in books

Students are motivated and take ownership of their learning

· The teacher follows KBA procedures and ensures that high standards of behaviour are maintained throughout

· Students demonstrate understanding of course content

See if the attached sample is doing what you want. 

If not, please provide a more detailed description of your problem, with all field and variable contents identified, and expected and actual results.

aguest.fmp12