none
Setting top margin

    Question

  • Here's the picture of a simple form I am trying to use to print labels. Please don't laugh!

     

    On this form I want to set the top margin of the large text box ([Input]) to match the value the user types in the "Top margin" text box ([LabelTopMargin]) after the user leave that box using the AfterUpdate event.  The code is:

    [Input].TopMargin = LabelTopMargin.Value

    However, the code rounds off the value of the user value to the next/previous whole number.  If for example, the user types in 0.6, the top margin of the Input text box is set to 1.0.

    However, the

    The problem is that

    MsgBox LabelTopMargin.Value
    [Input].TopMargin = LabelTopMargin.Value
    MsgBox [Input].TopMargin

    If the  

    MsgBox LabelTopMargin.Value
    [Input].TopMargin = LabelTopMargin.Value
    MsgBox [Input].TopMargin 

    • Moved by Yang,Chenfei Friday, August 16, 2013 2:23 AM Move Thread
    • Moved by Cindy Meister MVP Monday, August 26, 2013 9:54 AM access-specific issue
    Thursday, August 15, 2013 7:46 PM

Answers

All replies