Search results

I think I have found the source of the trailing blanks, and, perhaps Paul and others may have touched on it, but I was not schooled enough to pick up on the hint. If I create my table in design view (or perhaps with the Wizard), the trailing blanks don't show up. If I create the table using SQL...

vbaInet, the trailing nuisance only manifests itself in the form, not the table. Paul, If the table that is being populated from the form was created with an SQL statement such as DB.Execute "CREATE TABLE tblSomething (vField char(33)...etc. would that qualify for a "data type in SQL server"...

Thanks for the reply, jdraw. I tried that...seven ways to Sunday. I tried to put a trim on the field name in the form's control, trying to get the data to default to the trimmed format. I tried using a query in stead of the table, hoping the query would be more forgiving. I'm familiar with...

I have a table consisting of several string fields. I created a form to display the data in the table. When the data is displayed, each control automatically fills the field with the data plus any trailing blanks necessary to make up the entire alloted space in the field. This is not wanted...