create a custom paper size in vba

I have an application that uses a 8.5 x 13.25 I would like to check to see if the custom paper size is already created if it's not create a custom  paper size and name it report1_custom_size.
thanks
SvgmassiveAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

clarkscottCommented:
You may have trouble with this.  Reports are based on printer capabilities.  You cannot force a "normal page size" printer to print on paper larger than it can handle.

Therefore, I suggest you create the report - force it to a specific printer.

You can check to see if the specific printer is available per the PC, and you can check to see if the specific report exists, but you'll find much issues with trying to do this "on the fly".

At least per my knowledge.....

Scott C
SvgmassiveAuthor Commented:
hi clarkscott thanks for your response.I can create a custom  page setup in the print properties,give the setup a name the when the user selects the report the custom paper size name is selected not a problem.The problem for distribution purposes i am trying to avoid the user from selecting the printer properties to create the custom paper size i would like to create the custom set up via vba.

Thanks

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SvgmassiveAuthor Commented:
great
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.