Fixed column widths in SubForm

I've got a SubForm with 9 columns. Default View is Datasheet and all values for allowing other views are set to No. Can Grow and Can Shrink values for the sub-form and every object on it are set to No. Everything looks great, but when I open the Main Form in View mode, I can still go into the SubForm and adjust the column widths, which is exactly what I don't want to happen.

I'm obviously missing something somewhere, but I can't find any more sizing-related parameters to disallow. What else should I be looking at

Sponsored Links:

Related Topics

Cascading Combos in Subform v9999
Solved Thanks All

It feels like Ive trawled 10000 posts on this and tried almost as many attempts. Could somebody please look at this as Im bewildered. Not the normal problem. I have this set up just the way I want bar my 2nd combo after choosing the item from dropdown after update the control shows the Primary Key number. And yes I have bound and column count and widths right. (The column widths are set at .5;.5;3cm at the mo to try and let me see what is going on,,, it hasn't)


Autoresize column widths in Split Forms?
I have a Split form with the datasheet displayed at the bottom. Is there anyway to force autoresize of column widths everytime form is loaded? Even if I resized once the widths automatically resets again afters


Total Control Value in SubForm
I have a two controls on a continuous subform the row source for both is a query and Column(2) is a Name, Column(3) is a number.

These are displayed by setting Column Count and Column widths to suit. The whole picture is - the Main Form will have a Calculated Value I want to enter a number of entries in the subform and depending on the value allocated to each Name (location) I will then allocate a portion of the Total Cost to each name.

It's taken me ages to get a cascading combos where the 1st is on the Main and the Second is on the subform now I cannot total this value on my subform so until I can do this I cannot get apercent to allocate each Location Cost (does this make sense)

I'd hoped this might work but I don't think Column count can be used in an expression
=Sum([DestinationNo].[Column](3))
Also the subform record source is not the table where the values are stored which I feel is part of the problem


Access subform design question
I am designing a project management database. In the main form, I want to display main information about the project that corresponds to that record (project #, start date, milestone dates, etc.).

I also would like to have a subform that lets users add dated notes or updates to the project record. It seemed like something I could do with a subform, but I've never usedthem before,

What I did was to create a separate table called Updates that has the following fields: ProjectNumber, UpdateDate, UpdateText. I then linked the ProjectNumber from the Updates table to the ProjectNumber in the main table.

I was able to successfully insert the subform displaying the data from the Updates table, but had a few problems. First, I can't quite figure out how to NOT show ProjectNumber in the subform.

Really all I want to show is Date and UpdateText. Is there a way to exclude ProjectNumber? I noticed that I could drag the border of that column to make its width zero, but that doesn't seem like the most elegant way to solve the problem.

In fact, I'd like the column widths to be fixed if possible. Is there a way to do that?

Finally, I would like the entries in the subform to be sorted by date. How do I implement that? I played around with some stuff, but couldn't get it to work.


Controlling subform resize
I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data


Controlling subform resizing
and thanks in advance,

I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data.


Fixed values in a column?
Is it possible for me to make a table and have a column with fixed values.

My plan is to have a table that records can be added to (with one column already assigned).

The records will be added via a query.

I don't know if this is possible, is it possible to have fixed a column that records can be deleted and inserted without the values changing in one column?

Almost like an autonumber, but that does not change if you delete and insert records? That would be perfect


Fixed Format In The Report's Detail
Is it possible to have a fixed format in a report? If Yes, Could You help me by giving the procedures on how to do this or may be code.The report should have 2 columns with the data entry like most of you have probably done by just formatting the column width and height of the report. Now, My report should produce a hard copy with the same format everyday. What if only the first column has the data for this day and the next data should be filled up the next time. I want to display the Textbox in the next column even if there in no data entered to it. Got It? Any Idea on how to do this; fixed format in a report


Having problems with Combo Box (Form Control)
I have created several combo boxes which all have the same prefix in the name of the table: CB.

For instance, in the CB YNDK, there are two columns. The first is the ID, and the second is a column with the following: Yes, No, Don't Know.

Until recently, when I use the combo box (Form control) button, I am not able to choose the CB table I want to use but it creates a combo box which attached to the CB by checking the Table/Query data.

I then have to change the Column Count to 2 and change the Column Widths to 0. And sometimes this change doesn't happen and I have to keep playing with
the settings.

1) what's going on with the Combo box (Form control)? Why can't I select
which CB Table I want to use; and

2) What's going on with the column count and column widths settings?

I haven't made any changes (I.e. updates) to my Access 2007.


A Datasheet Conundrum
I've been playing with datasheets for weeks now. It seems like I've learned a lot, but I've been having problems setting column widths in certain cases.

There are three fields that vary widely in widths and I've found I can use the On Current event to resize them on the run. I have two forms. On one it works like magic. On the second one I am stumped. I've been using the .columnwidth = -2 very successfully, but on Form 2 it ignores whatever value I put in.

Here is an example I used to test the code.

' Me.ID_1.ColumnWidth = 4000 ' MsgBox "Column width is " & Me.ID_1.ColumnWidth

The message I get back is
Column width is 1860
This gives me the same result.

' Me.ID_1.ColumnWidth = -2 ' MsgBox "Column width is " & Me.ID_1.ColumnWidth


Subform Layout
I am using Access 2010 and amhaving an issue with a subform. I recently added a new value to the subform and now when I open the form containing the subform, the newly added value shows up at the end of the subform.

I have moved the column from the end to the position that I want it in in Design Mode, Layout View, Datasheet View, and saved each time before I switch views again, but no matter what I do,the column goes back to being the last visible column and the column width adjustments that I've made revert back to what they were as well.


Subform Layout
I am using Access 2010 and amhaving an issue with a subform. I recently added a new value to the subform and now when I open the form containing the subform, the newly added value shows up at the end of the subform.

I have moved the column from the end to the position that I want it in in Design Mode, Layout View, Datasheet View, and saved each time before I switch views again, but no matter what I do, the column goes back to being the last visible column and the column width adjustments that I've made revert back to what they were as well


Subform Layout
I have a subform that displays in datasheet view. I recently added a new value to be displayed in the subform. Naturally, the column went to become the last visible column in the subform.

What's weird is that now I cannot change the column position or width on any column in this subform. I've tried design view, datasheet view, layout view, and nothing works. I click save each time I change it before switching to another view. But when I reopen the form, they've gone back to the way they were before.

I can easily change column width and position on other subforms not related to this one.


Record updates on a subform
I have a subform, lets say subform A, which displays the contents of a table in tabular form. I have another subform, lets say subform B,

One of the columns in subform A is computed with another column in subform A, and a column in subform B, and I'd like that column to be updated whenever the user changes the values pertinent to that calculation.

and the after_update events work. but the change doesn't appear on the subform.

I have to change the record twice each time, and then the data shown is always one change back. I've tried requery, refresh, repaint, etc on that form after the update is done, and I can'tseem to get it to display the updated value, despite the fact that I know the calculation occurred and saved the record in vba via .edit and .update.


Columns in Combo Box
I have form with an unbound combo box based on a query. The query has to fields. The combo box has the # of columns set to 2 but only the first column displays the data, the 2nd column is empty.

I have the column widths 1",1". Not even the column head shows in the 2nd column.


Columns in Combo Box
I have form with an unbound combo box based on a query. The query has to fields. The combo box has the # of columns set to 2 but only the first column displays the data, the 2nd column is empty. I have the column widths 1",1". Not even the column head shows in the 2nd column.


How can I set up multi-row column titles in Access 2007?
I'm trying to handle some columns that have rather long names (titles). It would be easier to have the titles appear on two or more rows rather than just one, to avoid very wide column widths with narrow data fields. How would I do this?


not a db field - new field expression how to?
My query has sums I need to subtract from a fixed number and have of the report.

New field (name=balance) = fixed number (12) minus column b and column c.

I am having trouble getting the expression to work, I get prompted for the balance.


Pass Values from one Subform ontrol to Another Bound Control on the Same Form
I am trying to pass the value for the second column of a combobox in a subform to another control (on the same subform) which has a control source from the underlying query. I have: me!testcontrol = me![subform].Form![control].Column(1) in the afterupdate event of a control.

It work as I would expect it to when I open the subform all by itself. The second control gets the value and it is passed to the query.

However, when I run the the form/subform I get an error saying that it can't find the subform.


change recordsource on subform and show all fields
I have a form with a combobox where the user can make selections (select from approx. 40 queries). After making a selection, I want to have the results displayed on a subform. That subform is in Datasheet View, so the user will be able to change the widths of the columns etc.
The problem is that the queries have different number of fields, and the description is also different for every query.

Does someone know how I can create a subform where I can change the Record Source to another query and have al fields from that query displayed