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,

I fin dit out myself Trim(streetname)+" "+trim(house number)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.