By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Store a space ast last character

P: n/a
Hi all
I want to store a value in a field (datatype text) that has a space as
the last character. When I save this value Access deletes the last
space. Can it be done? what am I missing.

Best regards
Peter

Nov 21 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
MLH
Pardon my not answering your question directly, but would
you be comfortable adding it later - on the fly...

"This is my saved string" & Chr$(32) - or- & " " ???

Hope that helps.
Nov 21 '06 #2

P: n/a

MLH skrev:
Pardon my not answering your question directly, but would
you be comfortable adding it later - on the fly...

"This is my saved string" & Chr$(32) - or- & " " ???

Hope that helps.
Thanks for your answer,
The value is entered via a form with a bound text box.

Nov 21 '06 #3

P: n/a
MLH
If you're not too particular about it's being a Chr$(32), you can
click in a table text field and type

This is my string == and as soon as you press the "g", type
ALT-255 (ya gotta press the "255" on the numeric keypad)

That'll do.
Nov 21 '06 #4

P: n/a
MLH
try the ALT-225 thing

it ain't the same as a chr$(32) but most folks ain't
gonna know the difference.
Nov 21 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.