Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2012, 08:40 PM
JBaker JBaker is offline Whats the best way to do this....? Windows 7 64bit Whats the best way to do this....? Office 2007
Novice
Whats the best way to do this....?
 
Join Date: Apr 2011
Posts: 17
JBaker is on a distinguished road
Default Whats the best way to do this....?


At work they have been using a pretty simple form for the past few years that that base IT department made. I came along and customized the form a bit, making their lives easier with some drop down fields with following IF fields to give the rest of the text that did not fit in the drop down field due to the character limit.

They now want a way to insert about 60 lines into a drop down field or anyway that they can select a number, and it will populate the data that corresponds with that number. But, I do want that number to print.

Any ideas best way to do this?

Macros may be my only options, but Ive been trying to stay away from them, since the computers being used are on a server and have roaming users, and with 100 computers or so, and 140 employees that i have to enable macros on. just adds alot of work for me.

JBaker
Reply With Quote
  #2  
Old 04-03-2012, 11:54 AM
Charles Kenyon Charles Kenyon is offline Whats the best way to do this....? Windows Vista Whats the best way to do this....? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,128
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

60 lines
Are you talking 60 choices or one choice that take up 60 lines on the page?

If 60 choices, that is going to be one unwieldy drop-down!
Reply With Quote
  #3  
Old 04-03-2012, 05:14 PM
macropod's Avatar
macropod macropod is offline Whats the best way to do this....? Windows 7 64bit Whats the best way to do this....? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Dropdown formfields only support a maximum of 25 entries.

If your users want to insert a number, give them a text formfield into which they can type it. You can set the formfield's type to number with a maximum length of 2. You can also attach a macro to the formfield to validate the input, if needed.

Print-time suppression of a formfield's contents can only be achieved via a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 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