[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 105
  • Last Modified:

Need way to extend view in MS Access

Hi Techs, in the pic here, I am wondering if there's a way to extend the view of this box so I dont have to use the slider at the bottom.  There has to be a way....
Thank you
Mark88ims.PNG
0
Mark O'Brien
Asked:
Mark O'Brien
  • 23
  • 11
  • 5
  • +4
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
is this a subform? go to the design view of the form and click once on the subform control to select it. You will see resizing handles in the middle of each side and on the corners.  If you double-click a resizing handle, it will best-fit, but for continuous forms, you may want to make the height taller by dragging one of the bottom handles (like the one in the middle so it doesn't also change width) down.

If a best-fit makes it too wide, you may want to drag it in a bit -- and then remember to also drag in the right boundary of the form.  You can also set Width on the Format tab of the Property sheet (Alt-Enter to toggle display).
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
what's a subform
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
When I chose Design View, the whole thing closes out
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
aikimarkCommented:
What about making the columns more narrow?
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Then I cant see whats in those columns
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Alt+Enter doesnt do anything
0
 
aikimarkCommented:
Maybe you can display the fields in the currently selected row in a more vertical fashion to the side of the grid.
0
 
Gustav BrockCIOCommented:
.. extend the view of this box so I dont have to use the slider at the bottom.

What about making the columns more narrow?
Then I cant see whats in those columns

Then what do you imagine could be a possible solution?

/gustav
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Right, what else can I do?
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
if you make the columns narrower and need to see more in a particular control while looking at data, press Shift-F2 for the zoom box.

> "Alt+Enter doesnt do anything"
toggles the display of the property sheet on and off.

> "what's a subform"

a subform is form on another form.  I thought maybe it was because your screenshot shows a command button.  If this you want the WINDOW the form is in to be bigger, you can drag it by moving the mouse to an edge when the cursor changes to a double-headed arrow.
0
 
Gustav BrockCIOCommented:
You will have to rethink how data is presented for the user in the different situations the user will need access to these data.

/gustav
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Is there a way to get to Design View that wont close the program?
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
With just a screen shot of the form view, it is hard to know what you have.  Perhaps you can post a screen shot of the DESIGN VIEW? As Gustav noted, perhaps the data should be presented differently. Maybe you want a single-form with one record per screen. Maybe you want a continuous form with multiple lines per record You would have to modify the design after the wizard creates something for you if that is how this was made).  If this is a Datasheet form, all you can do is resize columns.

> "Is there a way to get to Design View that wont close the program?"
right-click on the title bar or tab and choose Design from the shortcut menu

You can also right-click on the form name in the Navigation Pane and choose Design
0
 
Dale FyeCommented:
You an change the font size of the text, to make it smaller.

How you do this depends on what version of Access you are using and whether this information is being displayed in a form, table, or query.

If you click on the upper left corner of the form/query/table, it should select all of the rows and columns of the object.  You can then change the font in those columns in the Home tab of the ribbon control.

You can also change the default size of text in datasheet view in the Access Options section of the database, under Datasheet, Default Font.

But if this is simply the results of a table or query, then you could create a form based on that table/query and display the controls almost any way you want on that form.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
> right-click on the title bar or tab and choose Design from the shortcut menu You can also right-click on the form name in the Navigation Pane and choose Design

Nothing happens when I do that
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
ims2  Here's another shot of the whole form
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
the form within the main form is called a subform.  In the design view, you can change the size of the subform control by selecting it and dragging a resizing handle.

It looks like the subform is a Datasheet.  There are other type of forms that will probably work better for the information that you have, as previously mentioned.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I am not in control of the form and I didnt create it, but Id like to resize that field
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
Since this is a datasheet, when you are looking at the data, you can resize a column by moving the mouse to the right boundary of the label in the column header and (1) click and drag, or (2) double-click to best-fit for what is currently displayed on the screen when the cursor changes to a vertical line with double-headed horizontal arrow ... just like in Excel ~
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I need to resize the whole box - the one in my first screenshot
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
then you need to resize the subform control in the design view  -- re-read my first comment

the subform control specifies the name of the form that will be displayed (Source Object), its size (Width, Height) and position (Left, Top), how it will be linked (LinkMasterFields, LinkChildFields), etc
0
 
Dale FyeCommented:
Looks like the form was designed for a monitor which is taller and narrower than your screen.  Do you know the person that created the application?  If so, they can probably make the modifications you ask for.

Do you have the original file (???.mdb or ???.accdb), or are you running opening this database with an extension of something like (.accde, .mde, .accdr)?
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
> then you need to resize the subform control in the design view  -- re-read my first comment

Please reread my comment first.  When I click Design View, the program closes
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I am making a copy off the server .accdb.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
perhaps other people are using the database.  Are the tables linked? When you look at the Navigation pane, do the tables each have an arrow in front of the table icon? If not, then the database needs to be split into a front-end and back-end so each person who is using it has their own copy of the front-end.

Front-end has forms, reports, queries, and code. Front-end links to tables stored in the back-end.

Back-end has all the tables.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
huh?
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
The main types of objects in an Access database are Tables, Queries, Forms, Report, Macros, and Modules. Tables can be linked to and shared.

While Access CAN be set up to be multi-user, it is not that way by default.  Something needs to be done. I am assuming since you couldn't go to the form design that either others have the database open or, perhaps you don't have privileges where it is located.  It also could be that the form design is protected and you need a password.
0
 
PatHartmanCommented:
With a form or subform in datasheet view, you can size the control by making it wider or taller or even rearranging the columns.  It works just like Excel.  Move your cursor to the line between the labels and watch it change shape.  Do the same at the left edge and move over the line between rows and watch the cursor change shape. However, the nice feature in older versions of Access that saved user settings is missing so for newer versions of Access, you would need to resize every time you open the form unless you can get the developer to make the changes permanent for you.

The quick alternative is to use the zoom box which as others have pointed out is shift-F2.

Please comment on these two ideas.  Both have been mentioned by others but you seem to have ignored them.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I tried the f2 thing and changed the font size, but it didnt change in the form
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
moving the columns doesnt help me.  ok........... I really need to extend the size of that box please.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
"that box" is called a subform. To change it, you have to be able to change the design of the form.  If you cannot get into the design view, you cannot change it and will have to do as Dale suggested and talk to whoever made it for you.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
The form creator isnt going to change it.
Now Ive done something to break it.  It doesnt call up Outlook email anymore :(
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Oh, that's probably b/c my email was missing in my last order.
What a nightmare
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
Before you make changes, always make a copy of the database. I realize that doesn't help you now ...

Access keeps a history of things that were done. If you modified code, go back to the code and press UNDO on the toolbar as many times as it can be done. Perhaps the code just needs to be compiled: from the menu in the code: Debug, Compile (the name of your database). If it highlights a line, there is a problem with it and you can fix it.

Don't change anything else till you back it up and note the date and time in the filename of the backup

Maybe your network team can get it the way it was from the last backup -- then you can replace the user interface stuff (queries, forms, reports, macros, modules) and leave the tables as they are since I am assuming they may have had records added or changed.
0
 
PatHartmanCommented:
No one said the zoom box would change the form.  Using it simply lets you see what is in the box without using the scroll arrow.

If you are not in control of the form - YOU CANNOT CHANGE IT!!!!!!!!!!!!!  That means that the methods that have been recommended do NOT change the form.  They simply make it easier to see.  Did you try increasing the height of the row?  Below are three pictures.
1. default
2. heightened rows
3. zoom boxResize.JPG
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
- unless my copy is just a copy off the server
0
 
Eric ShermanAccountant/DeveloperCommented:
Can you upload a sample or copy of the db so we can look at it more closer?

ET
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Pat, what did you type in there to make it do that?
0
 
PatHartmanCommented:
What did I type in where?
Pic 1 is the default view
Pic 2 - I moved the cursor to the grey box on the left and as you get it over the dividing line between rows, the pointer changes shape to a double headed arrow and you just click and drag down to make the row taller.  This is EXACTLY the same way Excel works.
Pic 3 - I clicked into the RateClass field - you can see that in the background form, it is still selected and I pressed shift-F2 to open the zoom box.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I dont think work would let me upload the db.  That has proprietary info in it.
0
 
PatHartmanCommented:
Mark,
Please try to respond to questions.  You specifically asked me a question that I tried to answer but without knowing what "that" is, it is impossible so I just guessed.  Where are we now?
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
It appears that I dont have the permissions to resize that subform.
Am I right?
0
 
Eric ShermanAccountant/DeveloperCommented:
<<<I dont think work would let me upload the db.  That has proprietary info in it.>>>>

Create a sample db with a few sample records that will re-produce the problem with your form.  That would take less time the all the back and forth plus guessing everyone is doing.  IJS

ET
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
no idea how to do that
0
 
PatHartmanCommented:
It appears that I dont have the permissions to resize that subform.
Am I right?

Open in new window

If you can't put the form into design view, then true, you cannot resize the subform.

Changing the height of a row in a subform in datasheet view does not require a design change so you should not be blocked.  Of course if the subform just looks like it is ds view but it is in fact not in ds view, then no changes are possible.  It is only forms/subforms in datasheet view that can actually be manipulated via the interface in an otherwise locked down app.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
if you cannot change the design yourself:
you need to go back to the developer anyway ... to resolve the #Name? error -- while there, ask that the subform be made wider and suggest how much wider ... 150%, 200%, etc -- based on how much more the monitor can show (get your ruler out)
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
thank you
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 23
  • 11
  • 5
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now