Trailing spaces in a text field

[Guest]

Need to store a trailing space in a text field.

Each time I enter it and move to the next record, Access insists on removing
the trailing space.

Any Ideas?
Thanks

 

[Guest]

Hi, Hubcap.

I can't help you with why Access does this, but you can add a space in the
control's AfterUpdate event:

Me!YourField = Me!YourField & Space(1)

Hope that helps.
Sprinks

 

[Guest]

Thanks - You gave me an idea

I ran an update query against the text field and concatenated a space on the
end - and it stuck

Again - Thanks

 

[Ken Snell [MVP]]

This is how ACCESS is designed.

While your procedure of using an update query to add the space will work
initially, note that, when that record is viewed / displayed / edited by an
ACCESS form, the space will again be removed.

 

[Guest]

Hubcap,

In light of Ken's revelation, why don't you just create the string with a
trailing space whenever you need it?

Sprinks