Re: how do I increase the field size in a drop down box



Something like this to run on exit from the dropdown:

Sub ExpandField()
Dim oFrmFld As FormFields
Set oFrmFld = Selection.FormFields
Select Case oFrmFld(1).Result
Case Is = "Bill"
oFrmFld(1).Result = "Bill Jones, 101 Miller Street"
Case Is = "Bob"
oFrmFld(1).Result = "Bob Smith, 57 East Maple Ave."
Case Else
End Select
End Sub

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


cproperasb wrote:
In my drop down box will be a list of names. When a name is
selected, I want the form to fill in additional information that is
hard coded, such as phone number, fax number and e-mail address for
that particular name. How can I do this?


.



Relevant Pages

  • Re: Select all when control gets focus
    ... Remote Programming and Training ... Private Sub Phone_Click ... since you are not storing the symbols, I hard-coded numbers in -- since the length in the control is> len... ... Bill Fischer ...
    (microsoft.public.access.formscoding)
  • Re: Run Macro during slide show
    ... tried to combine bills code that does work with what i thought would change ... Sub redx ... "Bill Dilworth" wrote: ... only while in edit view. ...
    (microsoft.public.powerpoint)
  • RE: Next record on parent form after update of child form
    ... The code that you are using to move to the next record, you mantion that you ... "Bill" wrote: ... > After adding/editing a record to a sub/sub form I'd like to move to the next ... > Are there special considerations when moving back from sub to main. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Move through a list box.
    ... Created a text box called txtBillHdn bound to the Bill field (the list box ... Private Sub btntstLst_Click ... First set the value of the list box to the newly ... the list selection is moving up and down. ...
    (microsoft.public.access.formscoding)
  • Re: Inserting Picture from File using VBA
    ... Thanks Bill. ... Sub Main ... 'Create a FileDialog object as a File Picker dialog box. ... Dim vrtSelectedItem As Variant ...
    (microsoft.public.powerpoint)