Size Of Forms
Mar 23, 2006I have a button on Form1 that when clicked opens Form2. I want Form2 to be a certain size everytime it opens. I can't seem to get this to happen, it always resizes depending on Form1 being maximised or not.
Dusp
I have a button on Form1 that when clicked opens Form2. I want Form2 to be a certain size everytime it opens. I can't seem to get this to happen, it always resizes depending on Form1 being maximised or not.
Dusp
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
I need to make the text size smaller to fit everything on the screen (users use 17" monitors..). I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ?
Also .. is there any way to make the autocentre option actually work as it's name suggests !! ? it does in most cases centre horizontally, but never vertically, quite often putting the top of the pop up form over the ribbon bar.
I would actually like to be able to totally remove the ribbon bar so that only the database forms are the only thing the user sees.
I vaguely remember being able to do this in Access 97 (Which was the last version I used - a long time ago !) but this seems to be more difficult in 2010 version.
When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max.
I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other things, but I cannot get those forms to keep their original size-they blow up!
How can this be accomplished?
When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max.
I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other things, but I cannot get those forms to keep their original size-they blow up!
How can this be accomplished?
I just change from a 1024x768 monitor to a 1600x1200. Now my database is squished due to the smaller pixel size and it is uncomfortably small. How can I adjust the DB to "fit" the new display, or any other monitor resolution setting.
View 7 Replies View RelatedI 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.
i just wanna ask can i set a field size for a textbox so that it can be entered only a limited number a words
For example, when i set field size = 8 and want to type beautiful, it will stop at "beautifu".
I have a subform that shows notes entered but if there is more text in the field then you cant see it all. Can I make it so that this field will grow so the whole input is visible or can I make it so when you click on it it opens in a larger window showing all the txt?
View 1 Replies View RelatedI 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 RelatedIt has been a month and I'm still 'stuck' on my Microsoft Access lessons due to a peculiar error. I have a video of the error, but it won't let me post a link until I have 10 posts. When I create an action button and then scroll at all, the button jumps in size 50% to the right and down, but this extra space can't be edited. Clicking on the 'extra space' is like clicking the background.
I have tried
1. Reinstalling Office 365
2. Reinstalling my graphics card drivers (Using a GTX 560ti SLIx2)
3. Manually entering the size for the buttons in the button properties (still increases in size)
I have a project where the schedule calls for a web-enabled database for 100+ users to merge five separate systems into one. If I can't get past this problem, I can't continue my lessons.
I have a form that has 2 subforms. When I try to print the current file there are a few problems,
1) When you use the print option in File menu, and select "Selected Records" , it will always print the second record, no the one selected.
2) No matter how often I change the printer properties , it will not keep the paper size I request.
Is there a script I could use to set the size and print the current record ?
im trying to autosize list box columns depending on the size of the largest field in the column?
View 1 Replies View RelatedI 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 RelatedWhen 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)?
I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do not, so their field is left blank. Lately when a new entry is tried in this field, only the first three characters are accepted, blocking character four through ten from being entered. It acts as if the text length for this text box has been changed to three characters, but it is still the correct length in the Properties box.
The system keeps track of clients who have attended a nutrition education class and the form involved is the location the class was taught.
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.
I have a datasheet on a form that is unable to show all records in the size allowed. Consequently it has a vertical scroll bar. However, the scroll bar allows scrolling to the bottom whereby there is white space almost the same size as the data records. The horizontal scroll bar does much the same.
Is it possible to just show the records and only the width of the data in them.? No extra records exist in the table to cause this.
Hi,
What should be done when the size of a database keeps getting bigger and bigger?
Regards,
B
I'm trying to create an mdb that is well over 2 gig and everytime it gets to 2 gig, I get an Invalid argument statement. Is there any way to bypass this process and create an mdb in excess of 2 gig? I've tried linking tables, queries, etc and I have also compacted and this mdb is simply that big.
View 14 Replies View RelatedI'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?
Thanks
scratch
I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need more space so that the user may see each letter of the category) Please help.
View 1 Replies View RelatedIn the time-honoured fashion of reducing the size of the front end of a db I imported everything into a new db. The size reduced from 32mb to 17mb. Success.
When I change anything, no matter how small, in the new db, it immediately increases in size back to 32mb. I always compact on exit.
This is annoying, rather than a major problem.
Am I doing something wrong or is this a “feature” of Access?
Access 2000 on XP professional.
Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.
Ta
Hi there..
we have one access database with size about 600mb and 1 million rows in one table.My concern is is it bad to have so much data in access database. If so what is the possible solution for that.
Thanks
Danny
Hey guys,
I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also tried to compact and repair the database. Can anyone give me some light on this situation?