Continuous form cuts of last pixel? (1 Viewer)

[CBrighton]

So I'm working on a new database to replace about 50 interlinked spreadsheets which are currently used.

I am designing a simple data input form, I won't go into the details of the relationships / structure I have setup as that's not the issue here but basically I am using a continuous form based on 4 tables (staff members, teams, tasks and team figures). There's no problem with this part, the key is that it's a continuous form with a varying amount of records (each team has different tasks).

As it's continuous and I know some of the people who will be using it are only experienced with spreadsheets rather than databases I decided I may as well make the data entry part look like a spreadsheet.

So I setup my column headers (labels in the report header), set the form to continuous, added the controls I needed, moved them so they are all directly next to each other (no gaps between them) and shrank the Detail section so there is no gap above or below the controls.

However when I open the form the bottom border of the last record is always cut off. With the other records it's a non-issue because the top border of the record below is directly touching the bottom of the control above so it still gives a grid effect, it's just the last record which is a problem.


To get around this I tried adding a line to the top of the footer and playing with settings like auto resize (form), can gro / shrink (detail) but I could not get it to automatically set the height of the Detail section based on the number of records.


Any suggestions?

 

[DCrake]

Don't use a continuous form. Use tab controls with subforms.

 

[CBrighton]

I shouldn't need tab controls as there are only about 5 controls, 2 of which are not enabled (there just to show the task name, etc)

Presumably you are suggesting I use a similar setup (line in the footer of cont form) in a subform with can grow set to true, will this cangrow property do what I want it to do?

My problem is that some teams will have as little as 2 tasks and others will have as many as 30, if I am putting the bottom line in the form footer then it needs to automatically resize it so the footer is directly below the last record.

Or are you suggesting that the subform be a single form with a tab for each task? if so I don't know how to populate a tab control with the appropriate number of pages and with captions pulled from the recordsource. I'm fine with tab controls in general but I have only used them statically rather than dynamically generated. Presumably I'd have to make more pages than I need and set the visible & caption properties from a VBA recordset?

 

[DCrake]

Can you post a screen dump of what you have now?

 

[CBrighton]

It's a new database in 2k3 format so I can attach the database itself if that is more useful.

 

[CBrighton]

I don't really want to seperate the tasks via a tab control so I started looking at using the subformcan grow, but had exactly the same issues.

I gave up and just set it to a fixed height with a scrollbar, but the problem with the border at the bottom of the final record being missing is still there.

 

[CBrighton]

No one has any idea on how to save my last row of pixels then?

 

[Lightwave]

I've seen this problem before in Access 2003 and I think it must have something to do with the dimensions of the design of lines in the form design being different from the resolution of monitors.

Have you thought about changing the width of the border of the fields in question? I think that might solve it but you might like the result even less.

 

[CBrighton]

Unfortunately the final row is still cut off. If I set the border to 2 pt then the final line is 1 pt.

 

[Lightwave]

Yes mine was a work around - the last option perfectionist realignment therapy?

 

[CBrighton]

Looks like I'll just have to deal with it looking like the data is going to drop out of the bottom of my table

That or I'll rename the query field names and set it to datasheet view.

Thanks for the suggestions though.

 

[Galaxiom]

This happens in A2007 too. I expect it is due to the line thickness compared to the screen resoultion. All the other boxes are actually two lines, one from each box.

I just separate the rows a little by adding a pixel to the Detail section of the form. It does give a doubled line look to the grid but I think that looks fine compared to the bottom row being cut off.

The easiest way to fix a bug is by calling it a feature.

 

[CBrighton]

I did try leaving a gap below, as you said the earlier rows then get a double line effect.

I'll take another look while purposely leaving a space between them horizontally so it's all double lines and see how that looks.

To be honest I'm not too bothered exactly how it looks as long as it's consistant!

 

[DCrake]

Have you tried inserting a line beneath the whole row the same colour as the textbox maybe 1pt in size and running it that way.

 

[CBrighton]

Before I tried the line at the top of the footer I tried it at the bottom of the detail section.

Unfortunately it makes no difference, as it occupies the final pixel it's still cut off.

 

[Spackman]

This is an old thread, but I thought I would give a work around for those who might stumble onto it. To solve this problem, I selected the fields of the continuous form and decreased the height property slightly. In my continuous form, I decreased the height from 0.2082 to 0.2028.