concatenation

  • Thread starter Thread starter Trillian
  • Start date Start date
T

Trillian

I'm trying to fill in a form field by stringing together
text and other field values from the form. The field to
be filled in is a text field that will be used as html
code - it contains all sorts of other symbols including
<'s, /'s and double quotation marks. The only problem is
the quotation marks:

Concatenate TextA with FieldB (appears in quotes) with
TextC with FieldD (appears in quotes) etc. The result
should be TextA"FieldBValue"TextC"FieldDValue" with the
contents (values) of FieldB and FieldD appearing, not the
names. If I use 3 double quote marks to get one to appear
(on each side of the fields) I get the names of the
fields, not the contents. My string looks like this:

[TEXTFIELD]="Text A" & """ & [FieldB] & """ & "Text C"
& """ & [FieldD] & """

Any assistance would be appreciated,

TIA!
 
use chr(34) instead of using treble quotes ;o)

e.g. chr(34) & text1 & chr(34) & chr(34) & text2 & chr(34) would show
"text" "text2"

Saved me alot of hassle in the past ;o)

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk
 
Back
Top