Combo Limitations?

[andysgirl8800]

Can a combo box, used to auto fill fields on a form, use a memo field? My selections seem to be cutting off at the 255 character limit, eventhough the underlying table is set to memo field. Is there a work-around for this issue?

 

[RuralGuy]

Maybe this thread will shed some light on the topic.

 

[andysgirl8800]

Tried That

Thank you RG. I had read that thread also. However, I have to have the SELECT DISTINCT ROW active to utilize the cascading combo I have set up on the form, or the fields will not populate correctly. If I cannot halt the truncating, is there any way to direct access to insert the remaning text into ANOTHER field? The cascading box is used to select medication names and when one is selected, a "reason" and "alternative" fields are auto filled. The "reason" field is the one I need the longer text in and is auto-truncating. If I created a second "reason" field, can I tell access to insert the leftover truncated text here? Is that possible?

 

[Rich]

Are you storing this data in more than one table?

 

[RuralGuy]

I would think you could use the ComboBox to locate the correct record and then use a DLookup() in the AfterUpdate event of the ComboBox to pull the full MemoField into your form. You are not storing the MemoField in more than one table are you?

 

[andysgirl8800]

Thank you for your reply. I am storing the memo field in 2 tables, the underlying table for the form (denials2), and the table for the drug names(tblDrug). I've verified that both are set to memo. How would I program the Dlookup and you've suggested, RG?

 

[RuralGuy]

There is absolutely *NO* reason to store the memo field in more than one table. There are tons of reasons *NOT* to store it in more than one table including keeping them both in sync. All you need is to store the primary key of the MemoField table in the second table as a foreign key and a query joining the two tables can display the memo field any where you want.

 

[raskew]

RG -

Congrats on 2000 posts! That's indeed impressive.

Bob

 

[RuralGuy]

Thanks Bob. I knew it was coming up soon but forgot to watch. Thanks for noticing. I seem to recall lifting several of your a97 routines for my cheat sheets. I enjoy reading your posts.

 

[indesisiv]

More character limitations in my combo box.

I am also having problems with this.
My combo's information is coming from a select query but NOT a select distinct. THere is no sorting etc.

Here is the senario:

I have a frame where I select and option - the combo box is linked to the value of this frame. I also have a text box that is linked to the 2nd column of the combo box to display the full text from a memo field. This is just for display purposes but it is truncating the characters of the text box at 255.

Any ideas

Thanks for any help
Steve

 

[RuralGuy]

Hi Steve,
You could easily be dealing with a limitation of the ComboBox. I don't think I would include a memo field in the RowSource of a ComboBox. I would probably use a DLookup to populate your TextBox with the ComboBox supplying the criteria.

 

[indesisiv]

Thanks RuralGuy

I'll give dlookup a go.

Steve

 

[RuralGuy]

I feel confident you'll have better results.

 

[indesisiv]

Works great now

Thanks

 

[RuralGuy]

Glad to hear it. Thanks for posting back.