How to append an operation specifications field with a carriage return.

unknown

Hello,

I am trying to append the statement in a specification field by adding a carriage return (Chr$(13)).  I have been successful adding the verbiage without the carriage return but it just runs together and doesn't look good.

I am using MS Access to do this and here is my current, failed attempt.

StrConv(([BITS]),0)+(Chr$(13))"~~~ C OF C AND MATERIAL CERT ARE REQUIRED WITH EVERY SHIPMENT ~~~"))

This gives me a syntax error.  Can anyone see my error and correct it for me please?

Thank you,

Paul

unknown

I've got it down to a data type mismatch with this...

StrConv(([BITS]),0+Chr$(13))+"~~~ C OF C AND MATERIAL CERT ARE REQUIRED WITH EVERY SHIPMENT ~~~"

and this...

StrConv(([BITS]),0+(Chr$(13))+"~~~ C OF C AND MATERIAL CERT ARE REQUIRED WITH EVERY SHIPMENT ~~~")