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

    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 offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    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
    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
    Ontario, Canada
    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.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Somerset, UK
    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
    Try again. Fail again. Fail better.
    sking for help isn't giving up. Its refusing to give up.

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