NearImpossible
Registered User.
- Local time
- Today, 14:35
- Joined
- Jul 12, 2019
- Messages
- 225
I have a ticket form created where the tech enters the callers name and phone number each in their own field. [FacilityPOC] & [POCPhoneNumber]
What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if it doesn't exist, they can just enter it.
I have this setup and working correctly so when a name is selected from the list, it is populated in the [FacilityPOC] field and their Phone Number is populated into the [POCPhoneNumber] field, however I was wondering if it was possible to set the [FacilityPOC] field size to a specific size, but when the tech clicks on the combo box, it would auto expand to the widest column to include both fields from the query.
Currently, due to the field size, I am getting the number cut off (See Attached). I would rather not increase the field size if possible as it is only used to display the name, however the drop down shows both the name and number.
If I increase the column sizes of the combo box, I get my desired results, but the user has to scroll to see their phone number.
I guess what I am looking for would be an auto expand to see the combo box results, but then an auto shrink after the selection is made to go back to its original size.
What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if it doesn't exist, they can just enter it.
I have this setup and working correctly so when a name is selected from the list, it is populated in the [FacilityPOC] field and their Phone Number is populated into the [POCPhoneNumber] field, however I was wondering if it was possible to set the [FacilityPOC] field size to a specific size, but when the tech clicks on the combo box, it would auto expand to the widest column to include both fields from the query.
Currently, due to the field size, I am getting the number cut off (See Attached). I would rather not increase the field size if possible as it is only used to display the name, however the drop down shows both the name and number.
If I increase the column sizes of the combo box, I get my desired results, but the user has to scroll to see their phone number.
I guess what I am looking for would be an auto expand to see the combo box results, but then an auto shrink after the selection is made to go back to its original size.