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

    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
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,406
    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
    30
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,214
    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.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,208
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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 - Senior Forums