Odd character for chr(10)

[Mark M S]

In a simple form memo field in Access 2002 I am pasting in a blank space by
using setvalue and chr(10) but a box shows up instead of an empty space -
any ideas?
*************************************************
Mark M Simonian MD FAAP
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

 

[Adrian Jansen]

A space is character 32 in Ascii. Character 10 is a linefeed.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Adrian Jansen]

Just another thought:

Even better to insert spaces is to use the Space() function

strText = str1 & space(1) & str2

Then you can insert as many spaces as you like, and its more obvious what
you are doing.

Also works in queries.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[fredg]

In a simple form memo field in Access 2002 I am pasting in a blank space by
using setvalue and chr(10) but a box shows up instead of an empty space -
any ideas?
*************************************************
Mark M Simonian MD FAAP
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

The square is Access's way of representing an undisplayable character.
Why are you adding chr(10)?
In Access that is a line feed character.
If you wish to add a blank space character, use chr(32).
If you wish to actually start a new line, use chr(13) & chr(10), in
that order.

And why are you using a macro instead of code?
In code you can simply use:
[MemoField] = whatever

Or if you wish to add to an existing memo field:
[MemoField] = [MemoField] & chr(13) & chr(10) & "This is additional
data"