How To Use The Len Function To Count A Space

[PC Datasheet]

How do I get the Len function to count a space at the end of a string? For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?

Thanks,

Steve

[Randy Harris]

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...

How do I get the Len function to count a space at the end of a string? For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?

Thanks,

Steve

Len will include a space at the end of a string.

?len("AB ")
3

[PC Datasheet]

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...

How do I get the Len function to count a space at the end of a string?
For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?

Thanks,

Steve

Len will include a space at the end of a string.

?len("AB ")
3

[jimfortune]

PC Datasheet wrote:

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...

How do I get the Len function to count a space at the end of a string?
For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?

Thanks,

Steve

Len will include a space at the end of a string.

?len("AB ")
3

http://groups.google.com/group/comp....4ecee81?hl=en&

James A. Fortune

If you have been aided by this answer, please consider a donation to
the following PayPal URL... :-).

[Randy Harris]

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Td******************@newsread1.news.atl.earth link.net...

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve

It's the text box that stripping your trailing space, not the len function.
You can confirm this rather easily.

In the form module create a int variable at the module level.
Dim intLen as Integer

In the BeforeUPdate event of the text box add:
intLen = Len(Me.tbxControl.Text)

Note: You have to use the .Text property to get the pre saved data.

Have your command button do:
MsgBox "Length of string:" & intLen

intLen will contain the length of the data in the text box, including any
trailing spaces.

Randy

[Terry Kreft]

You're testing the Value property which returns the underlying data not the
text you entered.

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry Kreft
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Td******************@newsread1.news.atl.earth link.net...

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...

How do I get the Len function to count a space at the end of a string?
For
example, if I enter AB(space), how do I get Len to return 3 instead of
2?

Thanks,

Steve

Len will include a space at the end of a string.

?len("AB ")
3

[Tim Marshall]

Terry Kreft wrote:

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry, unrelated question (apologies to Steve for hijacking his thread),
but what do you mean by "boiler plate" data in this case? It's not a
trick question... 8) I've used the expression a number of times myself
without a deep understanding of what "boiler plate" meant.... Thanks

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Terry Kreft]

Tim,
What I mean is, data as it is entered.
--
Terry Kreft
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:di**********@coranto.ucs.mun.ca...

Terry Kreft wrote:

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry, unrelated question (apologies to Steve for hijacking his thread),
but what do you mean by "boiler plate" data in this case? It's not a
trick question... 8) I've used the expression a number of times myself
without a deep understanding of what "boiler plate" meant.... Thanks

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[PC Datasheet]

Terry,

Thanks for responding!

Is there a way to check if a space is entered?

Steve
"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:wF********************@karoo.co.uk...

You're testing the Value property which returns the underlying data not
the text you entered.

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry Kreft
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Td******************@newsread1.news.atl.earth link.net...

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...
How do I get the Len function to count a space at the end of a string?
For
example, if I enter AB(space), how do I get Len to return 3 instead of
2?

Thanks,

Steve
Len will include a space at the end of a string.

?len("AB ")
3

[PC Datasheet]

My actual situation is that I have a continuous form with an unbound textbox
in the form header. The recordsource of the form is a query that uses the
value in the unbound textbox in the criteria of one of the fields. I use the
Change event in the textbox to run code to requery the form. I need to be
able to type AB(space)C in the textbox.

The following works --------------

Put the following under Option Compare Database:
Dim LenOfSearchFor as Integer

Put the following in the form's module:
Private Sub SearchFor_BeforeUpdate(Cancel As Integer)
LenOfSearchFor = Len(Me!SearchFor.Text)
End Sub

Private Sub SearchFor_Change()
Me.Requery
Me!SearchFor.SetFocus
If IsNull(Me!SearchFor.Text) = False Then
If LenOfSearchFor > Len(Me!SearchFor) Then
Me!SearchFor = Me!SearchFor & " "
End If
Me!SearchFor.SelStart = LenOfSearchFor + 1
End If
End Sub

Jim Fortune noted that Access won't automatically remove trailing
spaces that have been added through code.

Steve
"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...

How do I get the Len function to count a space at the end of a string? For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?

Thanks,

Steve

[Terry Kreft]

On an event of the control (i.e. the control has focus so we can check the
Text property)

If Len(Me.TextBox.Text) > Len(RTrim(Me.TextBox.Text) Then
' There's at least one trailing space in the text
Following on from this you can check how many triling spaces with
trailingspaces = Len(Me.TextBox.Text) - Len(RTrim(Me.TextBox.Text)

--
Terry Kreft

"PC Datasheet" <no****@nospam.spam> wrote in message
news:n1******************@newsread2.news.atl.earth link.net...

Terry,

Thanks for responding!

Is there a way to check if a space is entered?

Steve
"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:wF********************@karoo.co.uk...

You're testing the Value property which returns the underlying data not
the text you entered.

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry Kreft
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Td******************@newsread1.news.atl.earth link.net...

Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:ly******************@newsread1.news.atl.earth link.net...
> How do I get the Len function to count a space at the end of a string?
> For
> example, if I enter AB(space), how do I get Len to return 3 instead of
> 2?
>
> Thanks,
>
> Steve
>

Len will include a space at the end of a string.

?len("AB ")
3

[PC Datasheet]

Saved the last two lines for future reference.

Thanks, Terry!
"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:cS********************@karoo.co.uk...

On an event of the control (i.e. the control has focus so we can check the
Text property)

If Len(Me.TextBox.Text) > Len(RTrim(Me.TextBox.Text) Then
' There's at least one trailing space in the text
Following on from this you can check how many triling spaces with
trailingspaces = Len(Me.TextBox.Text) - Len(RTrim(Me.TextBox.Text)

--
Terry Kreft

"PC Datasheet" <no****@nospam.spam> wrote in message
news:n1******************@newsread2.news.atl.earth link.net...

Terry,

Thanks for responding!

Is there a way to check if a space is entered?

Steve
"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:wF********************@karoo.co.uk...

You're testing the Value property which returns the underlying data not
the text you entered.

Access does not store boiler plate data, it trims trailing spaces (bad
design IMO), hence 2 instead of 3.

Terry Kreft
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Td******************@newsread1.news.atl.earth link.net...
Thanks for responding, Randy!

I have two textboxes and a button on a form. I can enter a string in
MyTextBox and have code in the click event of the button to use the Len
function to output the number of characters I entered in MyTextBox. The
button code is:
Me!MyLenOfString = Len(Me!MyTextBox)

If I type AB(space) in the textbox and click the button, 2 appears in
MyLengthOfString instead of 3.

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:P2**********@newssvr24.news.prodigy.net...
>
> "PC Datasheet" <no****@nospam.spam> wrote in message
> news:ly******************@newsread1.news.atl.earth link.net...
>> How do I get the Len function to count a space at the end of a
>> string? For
>> example, if I enter AB(space), how do I get Len to return 3 instead
>> of 2?
>>
>> Thanks,
>>
>> Steve
>>
>
> Len will include a space at the end of a string.
>
> ?len("AB ")
> 3
>