Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-11-2019, 11:46 AM   #1
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 96
Thanks: 43
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
Old 09-11-2019, 11:50 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,610
Thanks: 50
Thanked 1,053 Times in 1,034 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Memo retention problem on a form in Access 2007

Hi. Not sure I'm clear as to what you're trying to do. Is this "memo" something the user will enter or modify? If not, and it's a permanent part of the form, then why not just use a label? Either that, or if the same memo applies to multiple forms, you could store it in its own table and use DLookup() to display it on a form.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-11-2019, 11:57 AM   #3
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 96
Thanks: 43
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Memo retention problem on a form in Access 2007

The db is for truckers to use to keep track of the travel records. I wanted them to have, at hand, a control to enable them to call-up some instructions, when they aren't sure what to do. I have several of these 'help buttons' on the form for them to use. That's why I want to be able to hide them. They use laptops and don't have a lot of screen space available.

I will try the 'label' suggestion. Don't know if I can 'show/hide' it, but will find out tomorrow.

Thanks for you help.

Punice

Punice is offline   Reply With Quote
Old 09-11-2019, 12:04 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,610
Thanks: 50
Thanked 1,053 Times in 1,034 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Memo retention problem on a form in Access 2007

Quote:
Originally Posted by Punice View Post
The db is for truckers to use to keep track of the travel records. I wanted them to have, at hand, a control to enable them to call-up some instructions, when they aren't sure what to do. I have several of these 'help buttons' on the form for them to use. That's why I want to be able to hide them. They use laptops and don't have a lot of screen space available.

I will try the 'label' suggestion. Don't know if I can 'show/hide' it, but will find out tomorrow.

Thanks for you help.

Punice
Hi. In that case, I would suggest using a popup form instead. It won't occupy any space on the current form and the user can move it out of the way without closing it.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-11-2019, 12:53 PM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,024
Thanks: 20
Thanked 381 Times in 374 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: Memo retention problem on a form in Access 2007

I'd second theDBGuy's suggestion.

You'd have a separate table that holds "Help ID" and your memo field.
You can then use a form, passing it Help ID, to have it display the memo you need for your help.

Mark_ is offline   Reply With Quote
Reply

Tags
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 04:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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