Re: Append truncates some text fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

--
Duane Hookom
MS Access MVP

"Chutney via AccessMonster.com" <u14792@uwe> wrote in message
news:67a8eb3666f44@xxxxxx
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?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200610/1



.

Relevant Pages

  • Append truncates some text fields
    ... When I append a text field from a staging table to the master table, ... The field is not indexed in the staging table. ... field for all records in the staging table is exactly 9 digits. ...
    (microsoft.public.access.queries)
  • numbers rounding up in table
    ... I have several tables that have numbers displaying 2 digits to the right of ... However, when I append these into a common table, all numbers ...
    (comp.databases.ms-access)
  • Re: How to manipulate a contents of file as record structures
    ... and append the sum of digits at the end. ... Gabriel Genellina ...
    (comp.lang.python)
  • Different destination fields
    ... I've got 2 fields in my database that represent Easting and Northings. ... to the way the client's db is set up, I need to append each of these values ... UTM's are the full 6/7 digits while Grid coordinates are usually 3 digits ...
    (microsoft.public.access.queries)