Turn off Name AutoCorrect with VBA?

[BradHodge]

I am being stricken with the A2K Name AutoCorrect bug with regards to reports changing margins and orientation. I understand that you can turn this feature off when creating objects, but I am guessing (incorrectly I hope) that this will fix this problem only for my computer.

If this is indeed the case, does anyone know if it's possible to turn autocorrect off as soon as a user opens the database (via a vba module or something)?

Thanks!

Brad.

[Denburt]

The following article explains how you can manually turn it off, if you need to use VBA let us know I am sure I can something to fit your needs.

"Taking the mystery out of Name AutoCorrect in Access."

http://office.microsoft.com/en-us/ac...345661033.aspx

[BradHodge]

The following article explains how you can manually turn it off, if you need to use VBA let us know I am sure I can something to fit your needs.

"Taking the mystery out of Name AutoCorrect in Access."

http://office.microsoft.com/en-us/ac...345661033.aspx

_______________ _______________ _______________ _______________ ______
Looks like that link you sent is no longer active (or just a problem with the site).

I have had no problem manually turning off Name AutoCorrect. I just need to know if you manually turn it off before creating Access objects, will this translate to other users PCs using the network version of the database?

If not... I do indeed need some advice on how to use VBA to turn off Name AutoCorrect.

Many thanks!

[Denburt]

I do believe this is a turned on and off per database type of an item. So if anyone is using that db then it should be set for them as well.

I do indeed need some advice on how to use VBA to turn off Name AutoCorrect.

That may take some effort I will try and do what I can if you or anyone else manages to find it please post it as it could be useful to others. Thanks

[BradHodge]

Sweet! That's what I was hoping to hear. I am currently working on the first report I have built from scratch since turning off the AutoCorrect. I'll update you when I try it out.

[BradHodge]

Well... Making progress, but...

It is now holding the Margins and the landscape orientation of the page, but it loses the "Legal" page size setting (reverts to Letter).

Thoughts?

Brad.

[Denburt]

In my module I typed in papersize highlighted it hit F1...Try that for AutoCorrect :)

Help file shows the following:

PaperSize Property
See AlsoApplies ToExampleSpecif icsReturns or sets an AcPrintPaperSiz e constant indicating the paper size to use when printing. Read/write.

AcPrintPaperSiz e can be one of these AcPrintPaperSiz e constants.
acPRPS10x14
acPRPS11x17
acPRPSA3
acPRPSA4
acPRPSA4Small
acPRPSA5
acPRPSB4
acPRPSB5
acPRPSCSheet
acPRPSDSheet
acPRPSEnv10
acPRPSEnv11
acPRPSEnv12
acPRPSEnv14
acPRPSEnv9
acPRPSEnvB4
acPRPSEnvB5
acPRPSEnvB6
acPRPSEnvC3
acPRPSEnvC4
acPRPSEnvC5
acPRPSEnvC6
acPRPSEnvC65
acPRPSEnvDL
acPRPSEnvItaly
acPRPSEnvMonarc h
acPRPSEnvPerson al
acPRPSESheet
acPRPSExecutive
acPRPSFanfoldLg lGerman
acPRPSFanfoldSt dGerman
acPRPSFanfoldUS
acPRPSFolio
acPRPSLedger
acPRPSLegal
acPRPSLetter
acPRPSLetterSma ll
acPRPSNote
acPRPSQuarto
acPRPSStatement
acPRPSTabloid
acPRPSUser

expression.Pape rSize
expression Required. An expression that returns one of the objects in the Applies To list.

Example
The following example sets a variety of printer settings for the form specified in the strFormname argument of the procedure.

Sub SetPrinter(strF ormname As String)

DoCmd.OpenForm FormName:=strFo rmname, view:=acDesign, _
datamode:=acFor mEdit, windowmode:=acH idden

With Forms(form1).Pr inter

.TopMargin = 1440
.BottomMargin = 1440
.LeftMargin = 1440
.RightMargin = 1440

.ColumnSpacing = 360
.RowSpacing = 360

.ColorMode = acPRCMColor
.DataOnly = False
.DefaultSize = False
.ItemSizeHeight = 2880
.ItemSizeWidth = 2880
.ItemLayout = acPRVerticalCol umnLayout
.ItemsAcross = 6

.Copies = 1
.Orientation = acPRORLandscape
.Duplex = acPRDPVertical
.PaperBin = acPRBNAuto
.PaperSize = acPRPSLetter
.PrintQuality = acPRPQMedium

End With

DoCmd.Close objecttype:=acF orm, objectname:=str Formname, _
Save:=acSaveYes


End Sub

[BradHodge]

I finally got it working.

As stated before, turning off the Name AutoCorrect made the report hold it's margins and Landscape orientation. However, the Paper Size continued to revert to Letter.

I ended up placing this code in the command button that opened the report...

DoCmd.OpenRepor t "MyReport", acViewPreview
MsgBox ("You must choose Paper Size: 'Legal' to view/print properly")
SendKeys "{RIGHT}"
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "%{DOWN}"
RunCommand acCmdPageSetUp

This opened Page SetUp and opened the dropdown box for choosing the paper size.

Thanks for all of your replies and direction Denburt!

Brad.

[Denburt]

I am glad you managed to get it working however, I so hate sendkeys... Yes they can get things done but they can be very problematic to say the least. I did a little digging and found the following article and I am sure you will find this useful.

http://support.microsoft.com/kb/290293


The link provides two methods of setting the default printer to legal as well as other properties and I am sure they will produce much more reliable results.

[BradHodge]

Indeed this appears that it would be a much better method of accomplishing this task. However, it appears that it will only work on Access 2002, 03 and 07. This database is written in 2k. I have however marked this page for use on my next '03 Db!

Thanks again for your help.

Brad.