Solved

[microwin88x]

Solved

[sunny_talwar]

Use Chr(39) for single quote.

UPDATE: I guess you are using Concat function or GetFieldSelections may be?

Try this if its Concat:

Concat(Chr(39) & FieldName & Chr(39), ',')

or this if it is GetFieldSelections:

Chr(39) & GetFieldSelections(FieldName, Chr(39) & ',' & Chr(39), 1000000) & Chr(39)

[hic]

Using Chr(39) will work, just as Sunny suggests. A second possibility is to use an escape sequence in your Set or Let statement. See Escape sequences

HIC