Restricting ampersands ("&") when doing XLookups

"Escape" the ampersand just before the XLU command.
```
 vStr = @Replace(vStr, "&", "\&")
```

Or, you can change the value of the data upon element exit.

vStr = @Replace(vStr, " & ", " and ")
vStr = @Replace(vStr, "&", " and ")

If you still want to block the keystroke, see the IgnoreKey() command in the Sesame User Guide.

Properties ID: 000236 Views: 1087 Updated: 13 years ago

Filed under:

Programming
Working With Your Data / Records