Start Free Trial
Unbound Memo Box
I would like to have my unbound memo show the text that was typed into it. When I close the form..the text goes away once the same form is opened again. Please let me know if you would like more info
8/22/2022 - Mon
I would like more info.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Scott McDaniel (EE MVE )
You cannot do this with an unbound memo unless you store the value the user entered somewhere, and then retrieve that when the form is reopened. You can store the value in a textfile, a database column, or a public variable (if you're reopening the form in the same session of Access).
If this is along the same lines as the other questions you've been asking, where you want to UPDATE the contents of other data based on what the user has entered, then you'll have to do this differently.
And, as before, all of this stems from an improperly designed database. Fix that, and you'll be able to do what you want with it. Until you do, you'll continually run into these sorts of roadblocks.
It was not my idea to have it unbound. I prefer to have it bound to a field in the table....
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent