Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2011, 08:17 AM
LAssist2011 LAssist2011 is offline Form Fields - Create blank form text field with if statement? Windows XP Form Fields - Create blank form text field with if statement? Office 2003
Novice
Form Fields - Create blank form text field with if statement?
 
Join Date: Nov 2011
Posts: 3
LAssist2011 is on a distinguished road
Default Form Fields - Create blank form text field with if statement?

I'm creating a rather elaborate form template for my office. I was wondering if there's a way to create a blank fillable text field depending on a dropdown selection.

So by default, there's one blank field that can be filled in to reference one person. But there's a dropdown that can be selected to include two, three, or four other individuals and I'd like MS Word to create another two, three or four blank text fields depending on the number of individuals selected to be placed in the document...



Essentially what I'm trying to do is this: {IF {REF Dropdown1} = something {FORMTEXT}}

Unfortunately, it doesn't work, and I think I might need to use a Macro. Not sure what to do here to get the effect I'm looking for.

If you understand what I'm trying to do I'd really appreciate some assistance.

Thanks!

Last edited by LAssist2011; 11-30-2011 at 10:12 AM.
Reply With Quote
  #2  
Old 11-30-2011, 02:28 PM
macropod's Avatar
macropod macropod is offline Form Fields - Create blank form text field with if statement? Windows 7 64bit Form Fields - Create blank form text field with if statement? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi LAssist,

You can't do that with field coding - a macro would be required. For some code to get you started, see: http://www.techsupportforum.com/foru...de-606391.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-05-2011, 09:46 PM
LAssist2011 LAssist2011 is offline Form Fields - Create blank form text field with if statement? Windows XP Form Fields - Create blank form text field with if statement? Office 2003
Novice
Form Fields - Create blank form text field with if statement?
 
Join Date: Nov 2011
Posts: 3
LAssist2011 is on a distinguished road
Default

I'm not an expert by any means with Macros and I went ahead and purchased a book or two on Visual Basic, hoping to learn something that might help me out. In the mean time, if you know the Macro I need to do, would you be able to lend me a hand?

So here's basically what I need to do:

The dropdown has two options, a singular and a plural. If the plural of the two options is selected, I want it to generate a fillable form field at a bookmarked location.

Then, that fillable form field I need to also generate another fillable area within the document.

So really, if I'm shown how to create that first fillable field, I can probably figure out the rest on my own.
Reply With Quote
  #4  
Old 12-05-2011, 10:02 PM
macropod's Avatar
macropod macropod is offline Form Fields - Create blank form text field with if statement? Windows 7 64bit Form Fields - Create blank form text field with if statement? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi LAssist,

Have you tried the solution in the link I posted? Apart from using a checkbox instead of a dropdown to trigger the creation of the additional content, the code etc is almost the same.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-14-2011, 12:12 PM
LAssist2011 LAssist2011 is offline Form Fields - Create blank form text field with if statement? Windows XP Form Fields - Create blank form text field with if statement? Office 2003
Novice
Form Fields - Create blank form text field with if statement?
 
Join Date: Nov 2011
Posts: 3
LAssist2011 is on a distinguished road
Default

Frankly, I find it confusing as there are a number of commands in there I don't need, and as I said, I'm not experienced with VBA and have actually only started using it.

I just need the option I select in a dropdown list (1 of 5 options) to generate more fillable text fields within a document.

I tried your example but I don't know where I need to make my corrections to suit my specific needs. I don't need the Macro to delete any options, only create them. I can show you the document I'm working on if you would like to see for yourself. Might be easier than trying to explain it.

I likely sound hopeless to you, but would appreciate if you are able to help me further lol

Thanks!
Reply With Quote
  #6  
Old 12-14-2011, 03:02 PM
macropod's Avatar
macropod macropod is offline Form Fields - Create blank form text field with if statement? Windows 7 64bit Form Fields - Create blank form text field with if statement? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi LAssist,

The code for deleting the added content is there in case the user changes their mind.

It might indeed be helpful if you attach a copy of the document to a post.

As for sounding hopeless, we all had to start somewhere ...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
fields, if statement

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Fields - Create blank form text field with if statement? Large amount of text as a form field. JustK Word 2 11-15-2011 11:17 AM
Form Fields - Create blank form text field with if statement? Strange formatting text color error in form fields.. rscafidi Word 2 10-16-2011 03:25 PM
Form Fields - Create blank form text field with if statement? Form Field - Drop down selection causing auto text chesspupil Word VBA 7 05-09-2010 05:43 AM
Form Fields - Create blank form text field with if statement? Text Form Field formatting problem Toshii Word 1 06-08-2009 07:21 PM
evaluating a text expression in a form field gwp1 Word 0 10-08-2007 02:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft