I tried searching the forums for the above title, and all I get is a bunch of excel posts that have nothing to do with what I am searching for. So I apologize if this question was posted before, but even a Google search turns up no results...I blame the Yahoo hack!
Anyways, I have two tables called Mechanics and EmployeeTimeSheet.
In the Mechanics table I have several fields, but the ones in particular are MechID that has an autonumber data type, and Initials which has a short text data type. The data in the initials column are all text.
In the EmployeeTimeSheet table, I have a field called MechName, and I initially set the data type to short text. I then use the Lookup Wizard to search for the initials from the Mechanics table, and I sort by Initials. As soon as I press finish though, the data type changes to a number. Why is this? All the data is text, there isn't a number anywhere. I started looking deeper into my tables and found this phenomenon in several fields where all the data is text, but it's being changed to a number, and it's really messing me up on my forms.
Can anyone explain why this is happening? I have deleted relationships and changed the data types back to short text, but as soon as I use the Lookup Wizard to create a list, it changes back to a number again. I have also noticed that the column count jumps from 1 to 2 when it changes to a number.
Anyways, I have two tables called Mechanics and EmployeeTimeSheet.
In the Mechanics table I have several fields, but the ones in particular are MechID that has an autonumber data type, and Initials which has a short text data type. The data in the initials column are all text.
In the EmployeeTimeSheet table, I have a field called MechName, and I initially set the data type to short text. I then use the Lookup Wizard to search for the initials from the Mechanics table, and I sort by Initials. As soon as I press finish though, the data type changes to a number. Why is this? All the data is text, there isn't a number anywhere. I started looking deeper into my tables and found this phenomenon in several fields where all the data is text, but it's being changed to a number, and it's really messing me up on my forms.
Can anyone explain why this is happening? I have deleted relationships and changed the data types back to short text, but as soon as I use the Lookup Wizard to create a list, it changes back to a number again. I have also noticed that the column count jumps from 1 to 2 when it changes to a number.