move top margin of form

[tziviak2]

I have a form that I use only the detail section of it-and in the detail section I have 30 fields-now-depending on the value of one of the fields-I want all the fields to move up/down accordingly-so I guess the best would be to make the top margin higher or lower (instead of coding for each field)
how would I go about it?
thank you (this form is actually a subform in another form-if that matters)

 

[dhookom]

Are you actually trying to print forms or are these reports? I don't think you can adjust any margins once a report has begun printing.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[tziviak2]

no-not when it starts printing-but every time-when I display this report-I want the fields to be positioned accordingly (the field won't change while printing-just every time I view it)

 

[tziviak2]

I tried this code:

Select Case Me!MONTH
Case 9
'Application.SetOption "Top Margin", 10
MsgBox Me!MONTH
Me.Properties.Application.SetOption "Top Margin", 2
MsgBox Me.Properties.Application.GetOption("top margin")
End Select

I put it in the detail section of the report -but I guess it's too late by then-but if I put it into the report_open then it can't recognize the month field

any ideas?

otherwise is there a way to select and move all the fields together (instead of moving the margins)?

thank you

 

[dhookom]

Again, I don't think there is anything you can do about this with a page header. If you state your real issue and specifications, maybe someone can help.

I'm still very confused about your use of "subform" and "form". Also, fields are columns from your report's record source. I assume you want to move controls, not fields.

You can use code to print values anywhere you want in the section and can modify the Top property of the controls as needed.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]