I use vb.net 2012 with Crystal reports
I have a report with two database fields :
streetname (char 25) and house number (char 10)
waterstreet 12a
walkingstreet 2544

But if i print the report it looks like this:

waterstreet                12a
walkingstreet              2544

But i want no only space(1) between streetname and house number.See below:

waterstreet 12a
walkingstreet 2544

Can i use trim function?

Thanks,