Append truncates some text fields

[Chutney via AccessMonster.com]

When I append a text field from a staging (temp) table to the master table,
some, but not all, of the data is truncated by 1 character.

The field definition is identical in both tables:
Data type = Text
Field size = 9
Required = No
Allow Zero Length = No
Except only the index. The field is not indexed in the staging table. It is
indexed (allow duplicates = Yes) in the master table.

The data in the field is a string of 9 digits (I use text because some of
them begin with 1 or more zeros.) The append query is a straight append with
no transformations on this field.

The staging table has 7025 records. I have confirmed that the data in this
field for all records in the staging table is exactly 9 digits. However,
after appending these records to the master table, 1391 of the records have
only 8 digits in this field (the right most digit has been dropped.) All the
rest have the correct 9 digits.

Does anyone have a suggestion as to what might be causing this apparently
random truncation?

 

[Duane Hookom]

I would check the Format and Input Mask properties. These may mask the
actual values contained in the fields.

 

[Chutney via AccessMonster.com]

Duane,

Thanks for the suggestion. There are no Format or Input mask settings for
this field in either table or the query. I have tried to find a common factor
in the truncated values (e.g. start with a 0) but cannot see one.

Regards.

I would check the Format and Input Mask properties. These may mask the
actual values contained in the fields.

When I append a text field from a staging (temp) table to the master
table,

[quoted text clipped - 24 lines]

Does anyone have a suggestion as to what might be causing this apparently
random truncation?

 

[Duane Hookom]

no clue...

--
Duane Hookom
MS Access MVP

Duane,

Thanks for the suggestion. There are no Format or Input mask settings for
this field in either table or the query. I have tried to find a common
factor
in the truncated values (e.g. start with a 0) but cannot see one.

Regards.

I would check the Format and Input Mask properties. These may mask the
actual values contained in the fields.

When I append a text field from a staging (temp) table to the master
table,

[quoted text clipped - 24 lines]

Does anyone have a suggestion as to what might be causing this
apparently
random truncation?

 

[John Spencer]

Like Duane I have not seen this behavior, but I would guess it is data
related. Could you post the SQL of the query you are using to append the
data? Are you manipulating the data in any way in the append query?

Are you sure about the field definitions? If the source table is defined as
more than nine characters in length and some of the fields had a leading
space or other non-visible characters then that could explain the dropped
right hand character.

Have you used the Len function to check the length of the data to see if
what you see (8 characters) is the same as what the database is storing?

no clue...

--
Duane Hookom
MS Access MVP

Duane,

Thanks for the suggestion. There are no Format or Input mask settings for
this field in either table or the query. I have tried to find a common
factor
in the truncated values (e.g. start with a 0) but cannot see one.

Regards.

I would check the Format and Input Mask properties. These may mask the
actual values contained in the fields.

When I append a text field from a staging (temp) table to the master
table,
[quoted text clipped - 24 lines]
Does anyone have a suggestion as to what might be causing this
apparently
random truncation?