Results 1 to 4 of 4
  1. #1
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20

    Memo Field - Dot Points

    Hi Guys,



    I have a simple "Progress Report" form with several memo fields in which I'd like to be able to enter dot points of information.

    I understand that I can set the text type to Rich Text and format using the Access toolbar, although the form is a pop-up form and I would prefer to set something up in VBA so that Access automatically adds a dot point when you enter the field, or when you hit enter to start a new line (Enter Key Behaviour is set to New Line in Field).

    Thanks in advance

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    So your default behavior is that there is ALWAYS a bullet point at the beginning of a line and you want this behavior regardless of circumstance?

  3. #3
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20
    Quote Originally Posted by rpeare View Post
    So your default behavior is that there is ALWAYS a bullet point at the beginning of a line and you want this behavior regardless of circumstance?
    Yeah that's right. Text entries will always be in dot point form

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    You might be able to do it through activating ribbon items (I think there's code to do that in access 2007+) Couldn't find any handy dandy code that would do it in a quick search.

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

Similar Threads

  1. Replies: 9
    Last Post: 07-21-2014, 11:57 AM
  2. Excel Import field truncation problem (to Access Memo field)
    By jhrBanker in forum Import/Export Data
    Replies: 6
    Last Post: 07-27-2012, 08:52 AM
  3. Replies: 5
    Last Post: 06-19-2012, 10:46 AM
  4. Replies: 1
    Last Post: 05-15-2012, 06:04 PM
  5. Replies: 5
    Last Post: 12-10-2011, 11:49 AM

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