Memo field

[Steph]

I have a database where people can store messages for each other. The
have their name, date, time of call and a message. The message field
is a Memo field, so people should be able to add carriage returns,
$%^&() characters.

However, sometimes it will show squares instead of the correct text.
But other times it will display the information correctly. Also it
will work correctly on some computers but not others. I am running the
backend on Office 2003 server and all other computers are running Win
2k, all have been SP'd and are up-to-date.

Can anyone help me with an explanation of why this would happen? Your
assistance would be appreciated.

TIA
Stephen

[Arvin Meyer]

Re: Memo field

The squares are most likely the Tab character: Chr(9) which is non-printable
in Access. Non-printing characters usually are seen as a square or a small
black rectangle.
--
Arvin Meyer, MCP, MVP
Microsoft Access

http://www.datastrat.com

http://www.mvps.org/access

"Steph" <steph_mw@hotma il.com> wrote in message
news:a04a6a04.0 409281750.127f5 232@posting.goo gle.com...[color=blue]
> I have a database where people can store messages for each other. The
> have their name, date, time of call and a message. The message field
> is a Memo field, so people should be able to add carriage returns,
> $%^&() characters.
>
> However, sometimes it will show squares instead of the correct text.
> But other times it will display the information correctly. Also it
> will work correctly on some computers but not others. I am running the
> backend on Office 2003 server and all other computers are running Win
> 2k, all have been SP'd and are up-to-date.
>
> Can anyone help me with an explanation of why this would happen? Your
> assistance would be appreciated.
>
> TIA
> Stephen[/color]