Re: Combining fields

From: spencer4 (spencer4_at_Comcast.net)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 10:54:36 -0400

OK, open a table using ACCESS and in a text field type
" This is a test. "
Move out of the field.
Move back into the field at the very end.
Where is the cursor? I think you will find it is at the period.

Your example didn't use the keyboard to input the data into a field in a table
(or a control on an ACCESS form) it used an SQL statement to populate the
field without the interface of an ACCESS table, query or form.

In other words, JET (the native db for Access) can store trailing spaces. In
most cases the Access input is done via a keyboard into a form, query
data*** view, or table data*** view. Access seems to automatically strip
any trailing spaces.

So if you are using the JET engine, but not ACCESS, then you can have trailing
spaces stored in the table.

At this point, I think we need to get back to the original question and
original poster - unless you are the original poster. I don't think you are,
since the knowledge you have displayed to this point indicates to me that you
would have no problem solving the original question.

Jamie Collins wrote:
>
> "John Spencer (MVP)" wrote ...
>
> > Jamie Collins wrote:
> > >
> > > "John Spencer (MVP)" <spencer4@comcast.net> wrote ...
> > >
> > > > Normally, Access fields DO NOT have trailing
> > > > spaces if they are stored in a
> > > > "standard" Access (Jet) table.
> > > >
> > > > I believe you can get trailing spaces into an
> > > > Access text field if you put them
> > > > there using a vba assignment; but, I would have
> > > > to check that to make sure.
> > >
> > > Here's a quick test that shows a text column/field in a Jet table may
> > > indeed store trailing spaces:
> > >
> > > CREATE TABLE NewTestTable
> > > (
> > > MyCol1 VARCHAR(255)
> > > )
> > > ;
> > >
> > > INSERT INTO NewTestTable
> > > (MyCol1) VALUES ('test ')
> > > ;
> > >
> > > SELECT
> > > LEN(MyCol1)
> > > FROM
> > > NewTestTable
> > > ;
>
> > And as I said you can do it using VBA. You can't do it inputting via the
> > keyboard into the table or into a query or into a control on a form.
> >
> > Or maybe that is what you are saying and you are just confirming what I said.
>
> I used a standard Jet table and a keyboard but not MS Access. Perhaps
> you could claify what you meant by, "Normally, Access fields DO NOT
> have trailing spaces if they are stored in a 'standard' Access (Jet)
> table."
>
> Jamie.
>
> --