formatting field

[wondering]

OK I know that I posted here not too long ago about the
same thing, but I found my problem I just need to know
how to fix it. I will try my best to give an accurate
decription.

I have a table called County_Reports
In this table is a field called County
When information is entered into this field, every
character that is not filled up (the field is 50
characters long)is translated as a space. No other
fields that I have do this and their properties are all
the same. Does anyone know why this is happening?

 

[Jeff Boyce]

What method are you using to confirm that the field is being padded with
blanks?

Does this only happen in "old" rows, or does only happen in "new" rows, or
does it only happen when data is entered directly in the table, or ...?

Can you use an update query and the Trim() function to "remove" the padding?

Just a few thoughts...

Good luck

Jeff Boyce
<Access MVP>

 

[Duane Hookom]

In addition to Jeff's comments, check the input mask property.

 

[tina]

-----Original Message-----
OK I know that I posted here not too long ago about the
same thing, but I found my problem I just need to know
how to fix it. I will try my best to give an accurate
decription.

I have a table called County_Reports
In this table is a field called County
When information is entered into this field, every
character that is not filled up (the field is 50
characters long)is translated as a space. No other
fields that I have do this and their properties are all
the same. Does anyone know why this is happening?
.
are you using an input mask on that field?