trailing spaces

[stevehooley]

Hi, I hope everyone is well.

As part of an extraction program I'm making, I've got a table (lets call it TABLE1) with values that have trailing spaces
e.g. "ENGINEERING ", "LOGISTICS ", etc....

This has been set up as such to match the values that exist in a read only table I am linking to from another database.

I have used a query of TABLE1 as a row source for a combo box. When the values are selected in the combo box the trailing spaces are lost.

Can I remedy this?

Thanks in advance

 

[KenHigg]

I think I would find a good spot to use the trim() function. Else, I suspect this will bite you over and over again...

Ken

 

[stevehooley]

Cheers Ken,

You're probably right. I'll just have to fiddle with the queries a bit.

I don't mind being bitten repeatedly by a beautiful lady, but by a database is just annoying.

 

[KenHigg]

I don't mind being bitten repeatedly by a beautiful lady, ....

.
.
.
.
tmi?