Question Memo field in query or report

[rw0706]

Hi, I'm having a problem showing a memo field in both my query and the report based on that same query. I can change the table properties to "text" instead of "memo" and it shows up fine, but when i set it to memo all I get is a bunch of these: . I need this comment box to be longer than 50 characters so I need the memo format to work. Using access 03.

Any help is appreciated - thanks

 

[ezfriend]

Textbox is default to 50 characters, but it can hold up to 255 characters. You just need to change the field size to 255.

 

[Rich]

Remove any formating from the memo field or at worst you can use DLookup on the Report to display it

 

[rw0706]

Thanks, forgot all about the 255 max. Changed it and everything worked nicely!