Member Avatar for dre-logics

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,

  • 1 Contributor
  • 1 Reply
  • 244 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by dre-logics
Member Avatar for dre-logics

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.