Clever Geek Handbook

Microsoft Access error: "This control has been disabled due to your security settings and current security policy"

Hi guys I am getting an issue with the Access 2007 application I am working on. Access acts as the front-end for SQL Server 2005. When I try to click a richtext control on a form, it gives me the following error:

Due to your security settings and current security policy, this control is disabled. Use the message bar to change your policy and enable the database.

After a little searching, suggesting adds a reliable location, however this error still occurs. Can anyone please help?

Many thanks.

+3


source to share


2 answers


Ok, so I found out the cause of this problem after a lot of trial and error. It looks like the rich text box control has limited support in Access 2007 . I found out that the rich textbox I'm using is Microsoft Microsoft Rich Textbox Control 6.0 (SP4) - RichTX32.OCX. Apparently this will throw the above error if activeX is disabled.

To fix this, I changed my registry entries as follows (although this also opens up security issues with IE):

  • Open regedit

  • Go to the next key:

    HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Internet Explorer \ ActiveX Compatibility {3B7C8860-D78F-101B-B9B5-04021C009402}

  • There should be a DWORD called compatibility flags . Set the value to 0 (default hex 400)



Some additional information that I found helpful follows:

+1


source


I recently found this? And started updating the control to work. Then I found the correct way to get the expanded text in a form in MSO 2007+:

Insert or add a rich text field

It says you need to have a memo field in the table and set its text format to Rich Text. Since the solution is a bit opaque, I'll continue what worked for me: then I'll go into the form design and create a text box. I have set the data source to a table field for a text comment; and its "Text Format" property for "Rich Text". I set the Scroll Bars property to Vertical.



I've now got a few nice text formatting options in Access 2010; but silly how they implemented them. There is no artist format. Also, if I want to, for example, set the Times New Roman font to 11, that won't let me; but turns it into 10; although I can also select 12 but not 11. If, however, in design mode I set the field font to "Times New Roman" and set the TAM font size to 11, the default font size is 11. I can insert things into it with step 11, first pasting them into Notepad to remove their formatting attributes, and then from Notepad into my box to get the text in step 11; or I can paste step 11 from somewhere else.

This has the advantage that some handy text formatting controls light up on the home ribbon and allow the elements to be formatted more or less correctly.

0


source






More articles:


All Articles