Textbox Question

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

How do you get the effect of the trailing dots like
GD321HN. . . .
in a textbox?
I am wanting to get the first 7 digits(letters/numbers) then display dots
afterwards.
 
How do you get the effect of the trailing dots like
GD321HN. . . .
in a textbox?
I am wanting to get the first 7 digits(letters/numbers) then display dots
afterwards.
Click to expand...

How many dots?
In an unbound text control:
=[FieldName] & ". . . ."
 
David said:
How do you get the effect of the trailing dots like
GD321HN. . . .
in a textbox?
I am wanting to get the first 7 digits(letters/numbers) then display
dots afterwards.
Click to expand...

Do you want the TextBox to still be editable?
 
that didnt not produce the effect that I was loking for, it produced an
error, I used
=[number] & ". . . ."
in the control source of the text box,
What I am wanting to do is get the 7 first digits the trail with dots, some
of the text is very long, this way I dont cut a digit off.



fredg said:
How do you get the effect of the trailing dots like
GD321HN. . . .
in a textbox?
I am wanting to get the first 7 digits(letters/numbers) then display dots
afterwards.
Click to expand...

How many dots?
In an unbound text control:
=[FieldName] & ". . . ."
Click to expand...
 
David said:
that didnt not produce the effect that I was loking for, it produced
an error, I used
=[number] & ". . . ."
in the control source of the text box,
What I am wanting to do is get the 7 first digits the trail with
dots, some of the text is very long, this way I dont cut a digit off.
Click to expand...

Make sure the name of the TextBox is not "number" then use...

=Left(CStr([number]),7) & "....."
 
No it doesnt need to be editable in this form, I have limited space on this
form and I am trying to not jam everything together. The string does need to
stay as was entered for editing on other forms.
 
I did get that to work , but when in a continious form it says ERROR, is
there a way to hide the word ERROR in a new record.
 
Back
Top