asked on
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
Microsoft Access
Last Comment
Jass Saini
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.
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.
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.
ASKER
It was not my idea to have it unbound. I prefer to have it bound to a field in the table....
ASKER
Thanks