2 memo Controls

[Dick7Access]

Another request from Mama???
She wants me to have two memo fields on a form so that with an extra long recipe it will roll any text that doesn't fit on the first memo over the second field, without having to scroll. . Now I know what you are thinking, why not make a very wide and very long memo field. The problem she had over 40,000 recipes and lots were just copied and paste from the net and has all the ingredient listed in a stack. It would take her forever to go in to them all and do a edit and have everything on consecutive lines. I told her it can't be done but that I would run it past you guys first. What say you?

 

[CJ_London]

you could perhaps adapt Stephen lebans code here

http://www.lebans.com/autosize_textbox.htm

in some way to determine how much will fit in the first memo control, and copy the rest to the other one

 

[Dick7Access]

you could perhaps adapt Stephen lebans code here

http://www.lebans.com/autosize_textbox.htm

in some way to determine how much will fit in the first memo control, and copy the rest to the other one

any idea what that db was made with? My A2013 can't open it. shouldn't 2103 be able to read anything on down?

 

[CJ_London]

seems it has user level security applied

I've converted to an accdb and attached - see how you get on.

going offline now so if it doesn't work, post a note, perhaps someone else can have a go or I'll look again tomorrow

 

[Dick7Access]

seems it has user level security applied

I've converted to an accdb and attached - see how you get on.

going offline now so if it doesn't work, post a note, perhaps someone else can have a go or I'll look again tomorrow

Thank You so very much.
It opened!
I love learning anything different with access.

Standing Offer: You come to FL look me up I will treat you to the very best Chinese Buffet in the whole United States of America and Texas.

 

[vbaInet]

Standing Offer: You come to FL look me up I will treat you to the very best Chinese Buffet in the whole United States of America and Texas.

You offered me the same thing Dick

 

[Dick7Access]

You offered me the same thing Dick

Absolutely, Lets have a AWF get together. I have only have one and we had a good time, except, I won't mention any names, he made me eat Buffalo.

 

[CJ_London]

Standing Offer: You come to FL look me up I will treat you to the very best Chinese Buffet in the whole United States of America and Texas.

I'll hold you to that - sometime

 

[Dick7Access]

I'll hold you to that - sometime

Yes, hold me to it. That is if you like Chines Buffets. It would be interesting to see if they are much different here than in the UK

 

[vbaInet]

I had Japanese food in a restaurant in NY last week, not much different.

 

[Dick7Access]

I had Japanese food in a restaurant in NY last week, not much different.

If you saying not much different from Japanese food in UK from J food in NY I will have to take your word it, as I have never had J food in UK and very little in US. Now the difference between J food in the US and Chinese Buffet in the US is like night and day. Now it has been many moons since I have been in the UK but my favorite food there was Fish & Chips, probable because that is what I was brought up on in Rhode Island. Within 25 miles of our house there were at least 30 Fish & Chip joints. One that is still there to this day is called Ye' Old English. It was there when my parents were kids. Same building. In fact same floor. It has solid black and white. marble, and very little sign of wear.

 

[vbaInet]

I would imagine that most of these restaurants source their ingredients (i.e. imported goods) from the same place, so the taste in food may differ based on the chef preparing it. Whereas if you were in China or Japan, it's sourced locally and everything is fresh.

 

[Dick7Access]

I would imagine that most of these restaurants source their ingredients (i.e. imported goods) from the same place, so the taste in food may differ based on the chef preparing it. Whereas if you were in China or Japan, it's sourced locally and everything is fresh.

How true, but that can be a hazard. One time while doing Navy duty in Dominican Republic ever one in the unit around 200 men got bathroom problems from fresh vegetables that the galley bought from a local source.

 

[vbaInet]

It was probably too fresh

 

[Dick7Access]

It was probably too fresh

We were told that it was probable because they fertilize with human excrement and that our systems were no use to it, and natives grew up with it from birth. Now how true that is I don't know.

 

[vbaInet]

Who cooked the vegetables, one of the servicemen or a local? And was it only vegetables? It could also be down to cross-contamination.