Results 1 to 12 of 12
  1. #1
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206

    RTF (rich text format) tool bar removal

    I have a
    RTF textbox on my form, works like I want it to, but if you click on it the
    RTF the tool bar shows. Is there a way to remove this option or a work around? My RTF box only shows info. and doesn't take any input. Not a big deal, all my searches say it can't be removed.
    Thanks,


    Tom

  2. #2
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    If I remember there is a send keys solution Cant remember where I saw it.

  3. #3
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123

  4. #4
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Works great!
    Thanks Tom

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    As its just for display, I think the simplest solution is just to disable the control. The rich text will still be displayed normally.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  6. #6
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    I think
    simplest solution is just to disable the control is the way to go!
    send keys solution works but has a quick flash of the FTF tool bar.
    Thanks for the help!
    Tom

  7. #7
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    May I ask what you are displaying and does it have to be on the form say for Use information or could it be added to a report?

    mick

  8. #8
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Hi
    That was why I suggested disabling the control rather than use send keys
    I had previously tried locking the control but to my surprise the rich text toolbar still appeared.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  9. #9
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Mick, I'm displaying info in VBA code to this RTF box on my form. Just wanted it to look this way.
    Thanks!
    Tom

    Code:
    Private Sub cboLocation_AfterUpdate()                       'Set Location info in Bins box
        On Error Resume Next
        Dim Bin As String
        Dim Storage As String
        Bin = "<B>" & Me.cboLocation.Column(6) & " </B><i>" _
        & Me.cboLocation.Column(1) & "    " _
        & "    </i><B>Row</B><i> " _
        & Me.cboLocation.Column(3) & "  </i><B>Col</B><i> " _
        & Me.cboLocation.Column(4) & "  </i><B>Comp</B><i> " _
        & Me.cboLocation.Column(5)
            Me.txtBin = Bin
        End Sub

  10. #10
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Not to worry just noticed this
    </i><B>Col</B><i>

  11. #11
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Mick
    If you look at the code before and after that extract, it does make sense.

    However there is a stray <I> at the end
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  12. #12
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Yeah I did get turned around a bit the fixed values through me was seeing the combo columns and missing the rest.

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

Similar Threads

  1. Rich Text Format in Access Field to Report
    By willowdom in forum Access
    Replies: 18
    Last Post: 09-10-2018, 12:40 PM
  2. Rich text field not displaying rich text properly
    By CodeLiftSleep in forum Access
    Replies: 4
    Last Post: 01-24-2018, 10:59 AM
  3. Replies: 3
    Last Post: 06-04-2017, 01:02 PM
  4. Trouble with rich text format memo field
    By lawdy in forum Access
    Replies: 10
    Last Post: 03-08-2014, 08:34 PM
  5. Set format of rich text field
    By silverspr in forum Programming
    Replies: 0
    Last Post: 03-28-2011, 09:07 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