Couple Design Issues

[dpasanen]

Hello, I'm putting the final touches on a form for one of our departments (who happen to be very picky about looks) and having a couple issues. (Using Access 2010)



Problem 1:
I have lines separating different sections of input and when I go to Form view the lines do not stretch to the right edge of the form. In fact, it appears that the form automatically increases it's width when switching. I tried turning Auto Resize off, but that just makes it worse.

Screenshot one - Design View with lines extending to the far right - http://i.imgur.com/pwCDt.png
Screenshot two - Form View with the lines not reaching all the way to the right - http://i.imgur.com/R3hat.png


Problem 2:
I'm using a Me.Requery for many of my buttons to update query data after changing things. After the Me.Requery is run, the text boxes' background change to grey instead of being transparent like they started. I've tried messing with the color schemes, but it doesn't seem to do anything.
Screenshot three - Before the Me.Requery - http://i.imgur.com/BA9pS.png
Screenshot four - After the Me.Requery - http://i.imgur.com/jeRkJ.png


Any help would be greatly appreciated!
I've searched for answers for both but am coming up empty.

[June7]

In design view, size the form window so the right edge border (the scroll bar) covers part of the right edge of the form (even on top of controls) and save it. Open in form view, can you still resize the form by clicking edge and dragging? Hopefully not.

Don't know about the colors. Would have to see code. Post it or the project for analysis.

[dpasanen]

Well, i got the form size thing fixed, had to re-enable Auto-resize and cover the right side with the scrollbar like you said. Thanks!

I noticed two of my total fields stays transparent after the requery, but all the others are still turning grey. I checked through the properties of them all and I'm not seeing anything different that would point at causing this.

One snippet of code that causes it to happen:

DoCmd.SetWarnings False
DoCmd.RunSQL "Update [TBL-Daily Counts] Set [SB FPs Completed] = [SB FPs Completed] + 1 where [ID]=[CurrID]"
DoCmd.SetWarnings True
Me.Requery
DoCmd.GoToRecord acDataForm, "FRM-Scoreboard", acLast

It is the Me.Requery that causes this to happen (when commented out, the boxes do not change), but I need it to do the requery to update all the text boxes in the form with the new data.

[dpasanen]

Found something out, if the text box is overlapping the label, and it is set to "Bring to Front" it doesn't change the background color. Very weird....

This would be a viable option, if I had labels by all my text boxes, but I don't. Tried to just "Bring to Front" on ones that didn't have labels near them and it didn't change.

[dpasanen]

Crappy workaround, but it does work. I just took my first, top left, label and expanded it across the whole form, then sent it to the back. Now all the text boxes stay transparent after the requery.....weird....

Thanks for the help!