I have a form that is pulling data from two different tables... we'll call them Table A and Table B.
Most of the fields on my form are from Table A, but there is one field on the form from Table B (it's a Memo field), that I've included as a combo box.
While the combo box field works okay on the form, it doesn't display ALL of the data in it on the form. Some of the records in Table B has lots of data (which is why I had to set it up as a Memo field), yet in my form, it looks like only the first 250 characters or so are actually displayed in this combo box field.
I've played with the column width and double-checked all of the Combo Box properties, but still only part of the data shows in my form for this field. Is it because eventhough it's a Memo field in Table B, it's a combo box in my form? Maybe you canly only display the first 250 characters of a combo box field? That kinda makes sense to me but it'd be great if someone could confirm that, as i haven't had any luck in finding information on the limitations of a combo box display in Access Help.
Thanks.
Earl
Most of the fields on my form are from Table A, but there is one field on the form from Table B (it's a Memo field), that I've included as a combo box.
While the combo box field works okay on the form, it doesn't display ALL of the data in it on the form. Some of the records in Table B has lots of data (which is why I had to set it up as a Memo field), yet in my form, it looks like only the first 250 characters or so are actually displayed in this combo box field.
I've played with the column width and double-checked all of the Combo Box properties, but still only part of the data shows in my form for this field. Is it because eventhough it's a Memo field in Table B, it's a combo box in my form? Maybe you canly only display the first 250 characters of a combo box field? That kinda makes sense to me but it'd be great if someone could confirm that, as i haven't had any luck in finding information on the limitations of a combo box display in Access Help.
Thanks.
Earl
