I have a series of word documents that I would like to slim down to just one document with a User Form. The documents in question here have a different number of editable fields in them based off the number of relevant questions a user has asked for a CVSA Exam. This can be anywhere from 2 to 13 questions. Right now, I have multiple forms for each number of questions. Is it possible for this to work so that the finished document either expands for the user when more questions are entered? There is a section of the form which has information in it after the section where the CVSA Exam questions are entered.
Are you wanting to turn a Word Document into an Access Form?
Daniel GoldenOP
@Reply 16 months ago
Alex,
No, I have a button in my access database which my users can click and open the word document. I am just wanting the userform in the word document to allow my users to select how many CVSA questions they asked during the exam and have only that amount of userform text boxes populate in the word document.
Yes. I found some information elsewhere that lead me to code the UserForm in Word so that if the user doesn't check a box for each question then when they click "OK" it will delete the bookmarked area on the form. The only problem now is that it is not moving my conclusion section of the form up to the end of the remaining bookmarks.
Daniel GoldenOP
@Reply 16 months ago
I think I just got it working actually. I added in some extra code and it seems to be working if I could just figure out how to change the formatting of the section when it moves it.
Could you try the Macro Recorder to give you a starter?
Daniel GoldenOP
@Reply 16 months ago
Alex,
I was able to play around with the code and get it to work the way I needed it to without having to mess with the format. Basically I made the code delete the parts between the data for the checkboxes and it automatically moves the conclusion section up where it needs to go.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Word Forum.
