Results 1 to 5 of 5
  1. #1
    TINMAN is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    64

    Is there a NOTE feature in Microsoft Access similar to that in Microsoft Excel

    Is there a NOTE feature in Microsoft Access similar to that available in Microsoft Excel. I would think if there was it would probably only be availabe in the Design View of the Report.



    I have attached a screen shot of the NOTE feature in Excel.

    Screen Shot of Microsoft Excel Note Feature-compressed.pdf

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    in the control properties, you will find controltip text under the 'other' tab. Note it will only work in Report view - not print preview. It also does not have the little triangle top right to indicate there is a note

  3. #3
    TINMAN is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    64
    I was able to fine the Controltip Text under the other tab. I put some text in there but it is not showing up in the Report view not sure what I am doing wrong!

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I find Control Tip to be flaky. Maybe you're not staying over it long enough for it to generate.
    Maybe you could use a double click event to provide a message (note) or have a small note form as a modal popup.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As Micron said, the ControlTip property has its drawbacks.
    The tip text is small and easy to miss. There is a delay of at least a second before it appears. Also if you have a bidden control 'above', the control tip won't appear at all.

    As well as the option of a small popup form, other possible approaches include
    1. Using status bar text - appears instantly but again easy to miss
    2. Using a hidden textbox made visible using a mouse move event and automatically hidden afterwards
    I use this method a lot and it can be used for hints on multiple controls on the same form.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2018, 07:46 PM
  2. Importing Information From Microsoft Word to Microsoft Access
    By Runlynch in forum Import/Export Data
    Replies: 9
    Last Post: 01-17-2016, 06:21 PM
  3. Replies: 13
    Last Post: 10-06-2015, 09:12 AM
  4. Replies: 1
    Last Post: 04-08-2014, 11:59 AM
  5. Replies: 1
    Last Post: 09-13-2011, 01:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums