Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Florida, USA
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill in form (XP)

    We have developed a fill in form this year for our Christmas project (hopefully will solve the problem of being unable to read the paper copies) I would like to force people using the form to fill in every field. Is there a way to do this?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Fill in form (XP)

    You can create customized Print (and/or Save) macros that block printing (and/or saving) unless the form has been completed. But one could sneak around this by putting a dash in the form field, etc. Hmmm. Is this what you had in mind?

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Florida, USA
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill in form (XP)

    well, I think the print macro would help-- I was hoping there was a way to keep them from leaving the field; but your solution would be a big step in the right direction-- unfortunately, I dont know how to create the macro

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Fill in form (XP)

    In a Word form, you can't prevent a user from leaving a field. However, when the user proceeds to a different field, you can scan the form and put the insertion point back into the first unfilled field. I've never actually programmed that, but based on previous dabbling I believe it is possible.

    The same logic of checking all the fields would be useful in creating a replacement print macro. Hopefully someone with a few more hours will be along to assist. (It's late here.)

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fill in form (XP)

    If you are needing more "intellegent" responses in your form, you will need to use the controls from the Control Toolbox Toolbar, which allows for VBA programming using events, and not the controls from the Forms Toolbar. Using VBA programming, you can add code to the controls Before Update or On Exit events to check if data has been filled in.
    Regards,
    Rudi

  6. #6
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Florida, USA
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill in form (XP)

    I will go look at it and see if I can figure it out-- glad to know there is a possible solution. Now, if one of you wonderful people could figure out how I keep from handing this form two or three times while doing the data entry into ACCESS; I would be a very happy camper.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fill in form (XP)

    Sorry, don't understand this ("keep from handing this form two or three times while doing the data entry into ACCESS")

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fill in form (XP)

    Please rephrase the question as I am being confused with how you structured that last sentence???? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •