field size question

[Sean G.]

Hello,

How do I see how large a field is (as in how many
characters are in the field?)

Thank you.

-Sean

 

[Allen Browne]

Try:
dbEngine(0)(0).TableDefs("MyTable").Fields("MyField").Size

 

[Jim/Chris]

In the table design in the General tab


Jim

 

[Sean G.]

I'm sorry, what I meant to say is, I want to cycle
through records on a form and have access know how many
characters are in the "client#" field Some clients have
more numbers in their field than others. I will be
making an IF ELSE off of the findings. Thanks.

-Sean

 

[Tom Ross]

You probably want to use the Len function to find the length of the string
stored in the client field

=len([client#]

BTW I don't recommend using '#' as part of a field name. It may force you
to make extra brackets or quotes or cause extra headaches. Try 'ClientNum'
instead

 

[Sean G.]

Thank you very much, that was very helpful...

-Sean

-----Original Message-----
You probably want to use the Len function to find the length of the string
stored in the client field

=len([client#]

BTW I don't recommend using '#' as part of a field name. It may force you
to make extra brackets or quotes or cause extra headaches. Try 'ClientNum'
instead

I'm sorry, what I meant to say is, I want to cycle
through records on a form and have access know how many
characters are in the "client#" field Some clients have
more numbers in their field than others. I will be
making an IF ELSE off of the findings. Thanks.

-Sean

.