Access 2002, Memo filed truncates.

[Guest]

I have a table with a memo field. I set the format property in the table to
caps, “>â€. This truncates the data for unknown reasons??
Any help?
Mark

 

[Joseph Meehan]

I have a table with a memo field. I set the format property in the
table to caps, ">". This truncates the data for unknown reasons??
Any help?
Mark

It's God getting back at you for using the devils ALL CAPS.

 

[RuralGuy]

I have a table with a memo field. I set the format property in the table to
caps, “>”. This truncates the data for unknown reasons??
Any help?
Mark

I think Allen Browne covered that.
http://allenbrowne.com/ser-63.html
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

The data truncated is less than 255 characters, about 150 or so. ??
Still don't understand the loss of data.
M

 

[aaron.kempf]

DONT USE MDB USE ADP

ADP works wonders for situations like this.
for starters, it keeps up to 8000 characters in a single field.. and
performance doesn't suck balls like it does for a memo field in Access

Can't group by memo fields

-Aaron

 

[Joseph Meehan]

DONT USE MDB USE ADP

Ever wonder why aaron bothers to read and reply to an Access newsgroup?

 

[Israel Richner]

He does the same thing on .NET, that dude just loves ADP and can't
imagine anything else. If you look at some of the threads he's posted,
almost 100% of the time he's not helpful in the slightest.

Hay Aaron....get a clue man.

 

[aaron.kempf]

BECAUSE ADP IS THE RIGHTFUL HEIR TO THE ACCESS NAME.

I LOVE ACCESS.

I REFUSE TO SIT AROUND WHILE YOU MONKEYS USE MDB IMPROPERLY; YOU ALWAYS
PREACH THE SAME WORK-AROUNDS.

WITH ADP YOU DONT HAVE TO KICK PEOPLE OUT OF THE DB TO TAKE A BACKUP

MDB DOESNT COMPETE

 

[aaron.kempf]

Israel;

why don't you stfu im right you're too slow

-Aaron