feathers212
06-25-2007, 01:20 PM
I have a form that is setup with many text and combo boxes. The MultiLine, TabKeyBehavior, AutoTab, and EnterKeyBehavior properties for all of these are set to 'False'. Most of the time, using the tab key moves the user to the next box in the tab order.
However, there are times when hitting the tab key actually puts a tabbed space in the box. I have no idea why this is happening (as all above mentioned properties are set to false).
This causes a major problem when the information is inputted from the form to my spreadsheet. It ends up transferring the tabbed space as two "squares". This is completely unacceptable as some of the fields on the sheet are used to create the file's name.
Any thoughts on why this is happening? Is there anyway to find and delete the "squares" once they are inputted on the sheet prior to using the cell information to create the file name?
However, there are times when hitting the tab key actually puts a tabbed space in the box. I have no idea why this is happening (as all above mentioned properties are set to false).
This causes a major problem when the information is inputted from the form to my spreadsheet. It ends up transferring the tabbed space as two "squares". This is completely unacceptable as some of the fields on the sheet are used to create the file's name.
Any thoughts on why this is happening? Is there anyway to find and delete the "squares" once they are inputted on the sheet prior to using the cell information to create the file name?