changing form dimensions in vb. - Microsoft Access / VBA

MissiMaths

Does anyone know of a way to change the length and width of a form in
code? Say if someone presses a button the form doubles in size to
reveal a some text boxes. I just need the code for the size changes if
such code exists?
Thanks in advance.

Nov 13 '05 #1

Subscribe Post Reply

4319

PC Datasheet

Me.Height = 2880
Me.Width = 5760

The above code will give you a 2" x 4' form. Measurements are in Twips where
1" = 1440 Twips.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"MissiMaths" <mi********@hotmail.com> wrote in message
news:75*************************@posting.google.co m...

Does anyone know of a way to change the length and width of a form in
code? Say if someone presses a button the form doubles in size to
reveal a some text boxes. I just need the code for the size changes if
such code exists?
Thanks in advance.

Nov 13 '05 #2

Bas Cost Budde

PC Datasheet wrote:

Me.Height = 2880
Me.Width = 5760

The above code will give you a 2" x 4' form. Measurements are in Twips where
1" = 1440 Twips.

Does that change the outside as well? Should me.height not be
me.section(acdetail).height?

docmd.movesize moves and sizes the form. I have seen utilities to
translate between the various coordinate systems, one is on
www.mvps.org/access

Nov 13 '05 #3

PC Datasheet

The poster asked about changing the size of a form to reveal a some text
boxes. You got to presume she is referring to a pop-up form. The given code
will change the overall size of a pop-up form including the title bar.

Steve
PC Datasheet
"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote in message
news:cm**********@news2.solcon.nl...

PC Datasheet wrote:
Me.Height = 2880
Me.Width = 5760

The above code will give you a 2" x 4' form. Measurements are in Twips where 1" = 1440 Twips.

Does that change the outside as well? Should me.height not be
me.section(acdetail).height?

docmd.movesize moves and sizes the form. I have seen utilities to
translate between the various coordinate systems, one is on
www.mvps.org/access

Nov 13 '05 #4

Similar topics

dynamic form needs to be static

by: Nancy | last post by:

Hi, I am working on a project where I have to make a form list static, i.e. put in links so that users can choose a local file. As it stands, it's looking for a php file. Here's an example of the...

Javascript

Form display position

by: John | last post by:

Hi I have a small pop non-dialog form that I need to appear towards the right side of the screen. Is there a way to achieve this? Regards

Microsoft Access / VBA

Determining a form's actual location (when it is not current)

by: Susan Bricker | last post by:

Greetings. I am trying to position opened forms so that they are cascaded on the screen. I have discovered the movesize action (for the DoCmd) and Move property of a form (for Acc 2002/2003). ...

Microsoft Access / VBA

Changing the background picture on a form with code

by: John Ortt | last post by:

Hi there everyone, I have a part info form which has a faded image of our company logo as a background. I want to replace the faded image with a bright red warning image on items which have run...

Microsoft Access / VBA

increase maximum size of Windows form (in Designer)

by: VMI | last post by:

How can I increase the maximum size of a Windows form? I'm trying to make a really big Windows form (about 1000x1000) but the designer doesn't allow me to do that. It only goes up to 1000x780....

C# / C Sharp

Changing text fiels dimensions in a form

by: atomD21 | last post by:

I am working on creating a form for potential clients to email me their name, email address and a comment about how I can be of service to them. I have the form basically completed, but I am running...

HTML / CSS

Retrieving Dynamic Form Data?????

by: bmallett | last post by:

First off, i would like to thank everyone for any and all help with this. That being said, I am having a problem retrieving/posting my dynamic form data. I have a form that has multiple options...

ASP / Active Server Pages

Changing image dimensions and saving as a gif - comments muchappreciated

by: almurph | last post by:

Hi, Hope you can help me wit this one. I have to open either a ".jpg", ".bmp" or a "gif" and alter its dimensions and save the output as a .gif. Here is my attempt - I would greatly...

C# / C Sharp

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware