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))
 
Back
Top