russi
07-21-2000, 11:09 AM
Hope you can help.
I have a Client table with an IDNUMBER in Number-type which is set to Double with a format of 00000000000. It has a name field.
The leading zero of IDNUMBER shows in the stored table.
In a second table, Work History, I have a multi-column combo-box combining the name field in 1 column and the IDNUMBER in the 2nd column. The bound column for saving is the 2nd (IDNUMBER). But when saved, the leading zeros are missing! - The format on the form and in the table are identical. Any ideas?
I have a Client table with an IDNUMBER in Number-type which is set to Double with a format of 00000000000. It has a name field.
The leading zero of IDNUMBER shows in the stored table.
In a second table, Work History, I have a multi-column combo-box combining the name field in 1 column and the IDNUMBER in the 2nd column. The bound column for saving is the 2nd (IDNUMBER). But when saved, the leading zeros are missing! - The format on the form and in the table are identical. Any ideas?