Table formatting

I have a table that has 10 characters in a "part" field.
There could only be 7 or 6 (variable) characters that are
actual, usable data. I have a form where a user can enter
the "part" # and a filter brings up data for that part BUT
I don't want the user to have to enter "sssCCCCCCC" (s=
space, c= character)every time.

Is there a way to format the data at the table or the
filter entry so it will match only the "usable"
caharacters and ignore the spaces?

Thanks!

They should not have to enter spaces.


123AAA
123AAA

Why would they enter spaces?

Do you prceed your name with spaces if the field is 10 charatcers long?

Bill
Bill

Am I missing something?





"Bill" wrote in message
...
I have a table that has 10 characters in a "part" field.
There could only be 7 or 6 (variable) characters that are
actual, usable data. I have a form where a user can enter
the "part" # and a filter brings up data for that part BUT
I don't want the user to have to enter "sssCCCCCCC" (s=
space, c= character)every time.

Is there a way to format the data at the table or the
filter entry so it will match only the "usable"
caharacters and ignore the spaces?

Thanks!

On Mon, 7 Jun 2004 11:13:40 -0700, "Bill"
wrote:

I have a table that has 10 characters in a "part" field.
There could only be 7 or 6 (variable) characters that are
actual, usable data. I have a form where a user can enter
the "part" # and a filter brings up data for that part BUT
I don't want the user to have to enter "sssCCCCCCC" (s=
space, c= character)every time.

Is there a way to format the data at the table or the
filter entry so it will match only the "usable"
caharacters and ignore the spaces?

Eh!?

Access truncates leading and trailing spaces anyway, by default. It's
possible but rather difficult to force it to retain the blanks.

If the user types A31XYZ into the field, that's what will be stored.
You can right justify it in a Textbox on a form or report for display
purposes.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John

Using GUI, I find Access truncates trailing spaces but
retains the leading spaces (unless code is used to remove
them). I have just did a quick test in DatasheetView of a
Table in AXP to confirm this.

In a number of imports I have done (C-Tree, Excel?), I
noticed also that Access retains the trailing spaces also.

Cheers
Van



-----Original Message-----
On Mon, 7 Jun 2004 11:13:40 -0700, "Bill"
wrote:

Eh!?

Access truncates leading and trailing spaces anyway, by
default. It's
possible but rather difficult to force it to retain the
blanks.

If the user types A31XYZ into the field, that's what will
be stored.
You can right justify it in a Textbox on a form or report
for display
purposes.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.

You can use the Like operator with wildcards in Filter.

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
I have a table that has 10 characters in a "part" field.
There could only be 7 or 6 (variable) characters that are
actual, usable data. I have a form where a user can enter
the "part" # and a filter brings up data for that part
BUT
I don't want the user to have to enter "sssCCCCCCC" (s=
space, c= character)every time.

Is there a way to format the data at the table or the
filter entry so it will match only the "usable"
caharacters and ignore the spaces?

Thanks!
.

The original table has the field and has the character length set as 10. When I enter a number for the filter if I don't enter the spaces to make the character string length 10, and match the table string exactly, it bombs. There has to be a way for when I call in the table or set up the filter for everybody to ignore the spaces and only focus on the text.

Thanks!