Re: I have to enter a space at end of textbox value for lookups

Clay Fox — Mon, 19 Nov 2007 20:12:19 GMT

It is your data type in access or sql. If you do not use a variable type then the field is always X characters and spaces are padded to the end of data to fit the field.

You can update the field in the DB to a NVarChar or something and then update all of your data to remove the extra space.

Or you can add a rule to your entered data to always concatenate the extra space needed on.

Or I think you could add the normalize function to your filter which would remove the trailing spaces from the list data and let you compare correctly.

I have to enter a space at end of textbox value for lookups

Ed Rodman — Mon, 19 Nov 2007 16:42:31 GMT

Clay,

Lookups are working, finally figured it all out. Only 1 strange behavior to ask.. When the user enters an account ID into the textbox, if the account ID entered is less than the field size of the table structure, we have to type in a space at the end of the text box. Do you know how to fix this feature?

Thanks Ed

Newbie Questions

Re: I have to enter a space at end of textbox value for lookups

I have to enter a space at end of textbox value for lookups