Access 2000: Text boxes.

[Kevin McCartney]

Hi TWIMC,

Is there a way to make a text box record what is typed into it, the problem is that I need to type in text and the text may need to have a space at the end, ( I may concatinate a variable to the end of it in code). The problem at the moment is that when I type in the text I want and try to but a space character at the end, the text box is updated and the last space is removed. I thought at first is was the auto update so I turned that off but it still updates and removes the last space.

I'm sure it's just an optoin setting but which one and where I don't know so I hope you may help,

TIA
KM

 

[Wayne Morgan]

Access will truncate trailing spaces. If you want to concatenate text in
code, add the space in your concatenation.

Example:
Me.txtMyTextbox & " add this text"

 

[Kevin McCartney]

That's just pants

Access will truncate trailing spaces. If you want to concatenate text in
code, add the space in your concatenation.

Example:
Me.txtMyTextbox & " add this text"