Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-11-2019, 11:46 AM   #1
Newly Registered User
Join Date: May 2010
Location: Middletown, VA
Posts: 108
Thanks: 47
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Memo retention problem on a form in Access 2007

I have a memo that I want a user to be able to 'show/hide', when a user opens it again to enter a new record's data or to view the memo for all older forms containing data.
I can show & hide the memo using a control on the form to toggle the 'visibe' property with vba.

Not knowing any better, I listed the memo in the same table as the form's record source. The execution of that control shows & hides the memo per the code for the form where, I guess I created it. When I open a new form or view any previously filled form all I get when I operate the control to show the memo is a blank field.

I am not clear on what I need to do or where to store the memo. And, the size of the memo is over 255 characters.

Spent several weeks trying, as well as, looking for guidance on the 'Net, before coming back to this forum for help (again), but all I could find are discussions pertaining to data type and nothing to really help me solve my problem.

Punice is offline   Reply With Quote

blank , form , memo

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 Add notation to memo field in multiple records Grover Queries 2 12-30-2012 12:07 PM
MS Access 2007 and the Infamous Memo Field duthiedon General 6 10-21-2011 05:27 AM
Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007 kfschaefer Forms 2 06-17-2011 04:09 PM
How can my memo/text box expand so i can read the whole thing? access 2007 yepwingtim Forms 5 03-26-2009 01:40 PM
Format selected text in RTF Memo field in MS Access 2007 ACF General 0 06-27-2007 11:47 PM

All times are GMT -8. The time now is 02:52 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World