S
Sean G.
Hello,
How do I see how large a field is (as in how many
characters are in the field?)
Thank you.
-Sean
How do I see how large a field is (as in how many
characters are in the field?)
Thank you.
-Sean
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Try:
dbEngine(0)(0).TableDefs("MyTable").Fields("MyField").Size
dbEngine(0)(0).TableDefs("MyTable").Fields("MyField").Size
J
Jim/Chris
In the table design in the General tab
Jim
Jim
S
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
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
T
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
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
S
Sean G.
Thank you very much, that was very helpful...
-Sean
-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
.