Combo box / memo problem

[Guest]

I have an issue with a combo box. It has a short ID field (KEID) and then a
long, memo field (KERqmt) as the source. I would like to save the KEID to the
table that the combo in linked to, but I want to display the KERqmt on the
form (no need to save this data to the table). The problem I'm having is that
only the first portion of the memo field is displayed (I'm guessing 255
characters?) Any idea why I can't display the entire portion of the memo
field. Everything looks fine when I look at it in the table.

 

[Douglas J Steele]

Do you have any format assigned to the text field, or are you using any
function on the value of KERqmt?

 

[Guest]

There's no format set to the field on the form. I tried setting it to "Memo"
but this didn't change anything. The format for the field in the table is set
to Memo.
--
Thanks,

Jason

Do you have any format assigned to the text field, or are you using any
function on the value of KERqmt?

 

[privatenews]

Hello Jason,


This is limitation since old version of Access. It still exist in Access
XP/2003. You could refer to the following article for details:

96987 ACC: Combo Box Displays Only 255 Characters of Memo Field
http://support.microsoft.com/default.aspx?scid=kb;EN-US;96987

If you need to view the entire contents of a Memo field, you need to use a
text box instead of a combo box.

Also, I have routed to your feedback on this to the product team and this
shall be taken seriously.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guest]

Thanks - saves me a lot of time trying to figure out what I'm doing wrong...

 

[privatenews]

Hello Jason,

Welcome. Thank you for your understanding on this.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.