UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Hide Mini Toolbar On Rich Text Enabled Control, Access 2016    
 
   
mtByte
post Mar 7 2018, 07:43 PM
Post#1



Posts: 12
Joined: 1-March 18



I know it seems odd, but I need to limit what can be formatted in a Rich Text enabled field/control on a form.

I only want the user to be able to alter the bold, italic, underline, and font colors within the control. I do not want the user to be able to alter font, font size, highlight/background color, numbering, bullets, etc.

I have a custom ribbon which facilitates the function I wish to allow, BUT I am not able to disable/hide the mini toolbar on the control when a user selects text, which allows for formatting of properties I do not want.


Attached File(s)
Attached File  RichText.MiniToolbar.png ( 8.85K )Number of downloads: 2
 
Go to the top of the page
 
theDBguy
post Mar 7 2018, 07:53 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,941
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Welcome to UtterAccess!
welcome2UA.gif

Not sure if I remember correctly but see if setting Allow Shortcut Menu to No does anything.

Hope it helps...
Go to the top of the page
 
mtByte
post Mar 7 2018, 08:04 PM
Post#3



Posts: 12
Joined: 1-March 18



Hi and thanks, re: Welcome...

No go on the Shortcut Menu set to No
Go to the top of the page
 
theDBguy
post Mar 7 2018, 08:56 PM
Post#4


Access Wiki and Forums Moderator
Posts: 73,941
Joined: 19-June 07
From: SunnySandyEggo


Bummer.
Go to the top of the page
 
mtByte
post Mar 7 2018, 09:01 PM
Post#5



Posts: 12
Joined: 1-March 18



Yep. Shortcut Menu mostly affects the right click context menu.

So, it is just me or does everyone here feel that Microsoft treats Access as the [censored] child in the Office suite? EVERY other Office application has an option for disabling this mini toolbar. Or do they just want to challenge us to write our own code to circumvent their shortcomings? smile.gif
Go to the top of the page
 
mtByte
post Mar 7 2018, 09:38 PM
Post#6



Posts: 12
Joined: 1-March 18



Finally found a work around!!!

Private Sub zSysRichText_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
SendKeys "^"
End Sub

Basically am just sending a Ctrl key stroke on MouseUp, which is enough to take focus away from the mini toolbar and hide it. Had tried sending Escape, but if nothing was selected (i.e. just clicking within the text box) it was actually functioning as an Undo/Ctrl-Z.
This post has been edited by mtByte: Mar 7 2018, 09:40 PM
Go to the top of the page
 
theDBguy
post Mar 7 2018, 10:44 PM
Post#7


Access Wiki and Forums Moderator
Posts: 73,941
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Nice going! Cheers!
Go to the top of the page
 
Peter Hibbs
post Mar 8 2018, 03:54 AM
Post#8


UtterAccess VIP
Posts: 1,613
Joined: 17-June 10
From: Dorset. UK.


Hi mtByte,

Very useful tip, thanks.

Peter Hibbs.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2018 - 12:36 AM