Problem Setting A Size Of The Form

Nov 23, 2005

Hi guys

In my database I have a main form and depending on the options chosen on this form other forms will pop up on the screen.

I want the main form to cover the whole page therefore in the On Open event I have used the Docmd.Maximize function. The problem is that after this point all the other forms will maximize once they are open! How can I stop the pop up forms from maximizing and make them open in a specific size? What code can I use for this?

Thanks

View Replies

Setting On-screen Form Size

Jul 14, 2005

Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.

View 3 Replies View Related

Setting Field Size In A New Table

Nov 15, 2011

how to set the Field Size in a new Table. I need the user to be able to type in 17 characters (as in a vehicle VIN). I don't want the user to have the ability to type in anything less than 17 characters or anything more than 17 characters.

View 2 Replies View Related

General :: Setting Printer Paper Size To User Defined

Feb 18, 2014

I want to set my paper size to user defined, but it not working,

<<<<<<<<<<<<<<<<<<<<<<<<<<
Set Application.Printer = Application.Printers("P1121E")
Application.Printer.PaperSize = acPRPSUser
Application.Printer.ItemSizeHeight = 9.35 Application.Printer.ItemSizeWidth = 26.9
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Showing "Run time error "2595"

"Cannot set this property when defaultsize property is set to true"

I try add "Application.Printer.Defaultsize = true or false" also not working

View 1 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

Will keeping your field size shorter result in a smaller MDB file?

Or does Access only use as much space as there is real data in its fields.

Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.

Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc

View 3 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

Form Size

May 4, 2005

hi all

i am new to access.I have a continous form with lots of coloumns.Is there a maximum size defined by access .

I checked this on the forms properties ..its showing the width for the form as 22".i tried to increase this but everytime it sets to this value.

Is there any way i can do this.

Thanks,

View 1 Replies View Related

Trying To Set Form Size

Aug 15, 2006

I am trying to set the form size through VBA code when the form loads.
I have autoresize set to No and then run this:
DoCmd.MoveSize 100, 100, 100, 100

...except nothing seems to happen. The form is still maximised.

Any ideas?

View 14 Replies View Related

Form Popup Size

Feb 23, 2005

Hi

All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.

Could someone please help me pls?

Thanks.

View 3 Replies View Related

One Form Maximized & One A Set Size

Dec 14, 2005

Good Afternoon,

I am writting a database and i am have difficulties with forms.

What i need to do is have one form (Main) maximized and the other windows set to a standard size, the main form is always visible the others need to be opened and closed via buttons on the main form and sub forms.

I am not sure if this can be done so any help would be good.

Alastair Lane:eek:

View 3 Replies View Related

Form Size When Opened

Jan 18, 2006

Hi
Is there a way I can make a form open to maximum size to fill the work area without click the forms Max button

dave

View 1 Replies View Related

How To Maintain Form Size

Mar 9, 2006

I have used the docmd.restore when closing a maximized report to keep the form from maximizing... but when I view a data sheet from my form then close the data sheet my form is maximized! Any help out there??:(

View 3 Replies View Related

Forms :: Setting Focus To Control On Single Form Side Of Split Form

Jun 24, 2013

When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.

Code:

If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If

Any way to set the focus to the single form Side of a split form?

View 4 Replies View Related

How Do I Lengthen Form Page Size?

Sep 5, 2005

I am adding fields to my form in Design View and I need to lengthen the page to make more room. Up until now, no problem, but now I am at 22 inches long and it will not expand any farther. I have just been grabbing the little bar at the bottom of page and pulling it longer, but now it has quit and won't let me make it longer. Is there a setting somewhere where I can make it so it can go longer. Surely Access doesn't limit your form page length to only 22 inches does it? Thanks!

View 2 Replies View Related

Form Size And Display Issues

Dec 28, 2005

Hello,

I have designed a bunch of forms that the user will access through the Switchboard. Things are working fine except that when I deployed the application to a different machine from mine, the forms appear to not display properly in the sense that they are appearing too big and the user needs to scroll horizontally to see it completely (which was not the case in my machine).

So, I just want to know if there is a setting that enables the forms to resize per the machine being dipalyed on or if I should have designed the form within a particular size that ensures that they displayed properly in most machine (fyi, most of my forms had a total horizontal width of about 9 on the horizontal ruler in form design view).

Any guidance is much appreciated. thanks.

View 1 Replies View Related

Forms :: Controlling Form Size?

Feb 2, 2015

I have one form "Products" that I have a button on which opens up another form. The second form lists a different number of lines depending on how many items are in a group.

The problem I am having is that I can not make the second form shrink or grow depending on how many line items I have in each group. Currently, I have to make the form as large as the most possible lines I could have (which is 19) but sometimes I might only have 5 lines in a form.

View 6 Replies View Related

Return Size Of A File In Form Text Box

Feb 17, 2005

A quick question that I'm sure one of you guys will be able to answer without any trouble, but I'm having difficulty with...

I have a form on which I would like to have a text box which returns the size of a file on my PC. The file path will not change.

Any ideas would be appreciated.

Thanks in advance.

View 1 Replies View Related

Button Face / Form Size Questions

Apr 20, 2005

1st of all let me say hi (newbie on this forum)

2nd: i started doing access about 3 weeks ago. and 90% of my knowledge goes to this forum. ur just great guys (or woman, if any here). cograts. (well to brag a bit, i made a form, subform table on it, can use checkboxes to filter data on the table (4 checkboxes), can add open a new form and add the data while the table subform is refreshed,etc... and like i said, i got it 90% from this forum). Who's da man?? YOU ARE!

3: my problems:
a) i want to either:
- change a face (pictucture) on mouseover or onclick
- use a picture for a button and change it on mouseover or onclick

b) i want to set a default size for my forms. now the problems are:
- the unists are in centimeters (or inches). i want pixels. screensize is in pixels so it's easier to adjust the form that way. i know that if i type for ex. 400px and move away it is converted to px, but is displayed in cm. any way to use px as default display units?

- the form has the size of the whole window instead of just the grid. what's the trick? (i mean if i say 400px, the grid is 400px. but if i have a gray area 200px more (design view), then when the form is opened, it will be 600px). huh?

c) can i get rid of the scrollbars if i don't need them? and they will auto appear when needed.

Thanks for the answers. And again, even if i don't get any, this forum is by far the best. (well for access anyway ;)

d) is there a "mailto" function i can run with onclick [command button]?

Bye for now
Josh

(oh you can reply here or by mail: joshlyman_slo@yahoo.com)

View 5 Replies View Related

Changing Form Size According To Screen Resolution

Oct 13, 2005

Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this.
I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution.
E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res.
Thanks for any replies :D

View 3 Replies View Related

Sub Form Increase In Size Depending On Data

Sep 29, 2006

I have a main form with a few imbedded sub forms.
Sometimes these is a great deal of data in one of the sub forms & non in the others.
Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data)
The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible.
Can anyone help with ideas please?

View 2 Replies View Related

Help Needed To Change Form Size/resolution

May 2, 2005

I hope I can explain this clearly.
I have a subform that has a lot of information and I was wondering
if there is a way to make the subform appear as if one turned up the
resolution, thus making it's contents smaller, allowing me to pack more info
in it. I would love to leave the size of the main form alone.
I'm using Access 2000.
The sub form is currently displayed as datasheet.

View 1 Replies View Related

Forms :: Size Of Modal Popup Form

Aug 27, 2014

I am having issues with a split form which modal and emergent (pop-up) properties are set to yes. When I open it, it is maximized or out of the size I had setup; although I saved it trying to "freeze" the height and width.

View 11 Replies View Related

Set Property For Form Size In Pixels Rather Than Inches?

Nov 3, 2014

I want to set the size and shape of my forms to exactly fill a screen at a particular screen resolution. I can only see a width property in inches and nothing in pixels. Is this possible?

I know I can set the fit-to-screen property to yes but this isn't what I want. I don't want a form to fill a screen at any resolution. If a screen is a higher res than the size I've formatted the form for I want it to appear the same size on the higher res screen (i.e. with a border of background around it.)

Is this possible?

View 5 Replies View Related

Forms :: Field Auto-size To Text In Form?

Nov 19, 2014

I am relatively new to using MS Access 2010. Some fields which i have set up as Memo fields to take report comments. Is there anyway to make the size of the memo field box variable to fit in with the text in the form when viewing in htis mode?

View 1 Replies View Related

Forms :: Design View - Reducing Form Size?

Sep 24, 2014

When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.

How can I reduce the form size (so it looks like an Excel form)?

View 6 Replies View Related

Forms :: Set Field Size On Form To Read 6 Decimals

Mar 6, 2015

I have a form to input data into a table1. On the form I have a combo box to read from a next table exchange rate to input into the table1. Field in Tablet for the exchange rate is set to Field size double, Format currency, and decimals 6.

I am unable to set the field size on the form to read the 6 decimals. The combo box is set to Currency decimal 6. I tried General Number and it still only shows only one decimal.

View 5 Replies View Related