Combo Box Question with Spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo

I have the following problem with a combo box where it cuts of spaces at the
end of the text example

( 1N1G- 6007-BB ) This is how it should be the field length is
always the same so where there is no characters it must give me a blank space
in the front and the middle its ok just at the end it cuts them off how can I
prevent that from happening its very important that they are there because in
your company tables if there is not character there is a blank space and if I
don't give indicate it in my query that there is blank spaces it does not work

I hope some one can help

Markus
 
Regardless of the defined length of a field, it only stores the actual length
of the data entered. This will include leading and embedded spaces, but not
trailing spaces. If you need to have trailing spaces displayed, then you
will have to pad it with spaces:

x= space(desiredlength - len(x))
 
Regardless of the defined length of a field, it only stores the length of the
data entered. This includes leading and embedded spaces and excludes
trailing spaces. If you want to display the spaces:

MyString = MyString & Space(DesiredLength - Len(MyString))
 
Regardless of the defined length of a field, it only stores the actual lenght
of the data entered. This included leading and embedded spaces but excludes
trailing spaces. To display the length you want:

MyString = MyString & Space(DesiredLength - Len(MyString))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To Avoid Blank Space in Combo Box 2
Aligning fields in combo box expression 4
Combo Box Text not appearing 8
Access Access anti-trim?? 0
Combo box problem 1
Very specific Question??? 1
Issue with blanks and spaces 56
my combo boxes 2

Back
Top