Hello,

I am using Microsoft 2010 and have a protective document with a table built in that has form fields. The problem that I am having is that, I want to tab to create a new row, with the form field boxes in there, so the users can continue to enter their information.



I am able to create a new row when tabbing, but it doesn't insert the form field boxes.

Can someone point me in the right direction to find this out?

Thanks.

No of course not. You have to unprotect and insert new formfields.

Sorry, I guess I'm not explaining that right, the document is protected to keep those that are using it to get it all out of format, though I looking to be able to hit tab and a new row will be created with the form fields populating - they will be blank because the people will enter in their data, but the field lengths will already be set. Hope that makes sense. Seems like there should be a way for this to be done, even if I have to incorporate some type of VBA code.

Like I stated, any new rows will be empty. You have to make the formfields.

BTW what exactly are you doing to make the new row, because using tab WHILE the document is protected will not make a new row. So, please explain precisely what you are doing.

In any case, as previously stated:

If you're using formfields in a document protected for forms, you cannot create a new row by tabbing out of the last one.

There are, however, macro solutions that ask whether to add a new row when tabbing out of the last formfield on the last row. These will automatically add the new formfields as well. See, for example:
http://msgroups.net/microsoft.public...to-table/42026
http://answers.microsoft.com/en-us/o...2-ca4fd5b67465
Whether those solutions might work for you is unclear - your user profile (which you've set) suggests you're using Office 2007 on a Mac OS X system, whereas most Macs would use Office 2008 or 2011, but your post refers to Office 2010. Office 2008 has no macro support. Both Office 2007 & 2010 are Windows applications.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you, I think I'm really stuck because I am a beginner, and the VBA is overwhelming. You all are correct regarding the protected document piece, but how do I make this work? I see code that is close, but it is a little bit complicated to figure out how to alter the code to get it to work with my particular document.

Here's what I have:

1. Created a form template that is supposed to be protected. (Or can some fields only be protected, so that they can fill out the necessary parts?)
2. Content controls in the fields

What it needs to do:
1. Restrict users from making unnecessary changes to the document
2. User needs to enter data in fields (which are content controls)
3. *** This is where I need the most assistance *** When the user hits the enter key or tab key on the field at the end of the row, it needs to create a new row with all the fields (including the content controls), so that if the user needs to enter new information for that line, they can do so, and it will be set in format.

Please help.

Thank you.

Please clarify what platform you're working with (i.e OS & Word version) and whether you're using content controls or formfields. You should not be using both in the same document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm using Word 2010 on Windows 7. Sorry my platform in my profile shows differently, because that's what I work with at home. Sorry about the confusion.

I am using content controls, but can use formfields if that will work better. I'm totally lost, and am looking over someone's code to try to decipher it enough to make it my own, but I'm just stuck.

Thanks.

See attached content control demo. When you exit the last cell in the table, you'll be asked whether to add a row. To see the code behind this, Press Alt-F11 to open the VB Editor and look in the document's 'ThisDocument' module.

Attached Files

Content Controls - Table Row Add.zip (35.9 KB, 15 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you macropod, that is EXACTLY, what I'm needing it to do, but how to I make it work. I tried to run it behind my own, but what do I need to alter to make it work?

Thank you so much!

For the example posted, all you need to do is to copy/paste the code to your own document's 'ThisDocument' module and have a content control (of any kind) in the last cell of the table. From then on, any time you exit that cell, you'll get the prompt.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

It's still not working, can I send you the form?

You can attach a document to a post with some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

It's the rows where you enter Object Type, Object Name, etc.

Attached Files

test-form-newrow.zip (37.5 KB, 13 views)

Without wanting to place too fine a point on it, that document has formfields, not content controls... Please review what you wrote in post #8: https://www.msofficeforums.com/word/...html#post54082

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]