Post reply

Name field in a report - formatting issue

  • November 19, 2014 at 1:17 am

    #313264

    Hello

    In one of my reports a name field is bringing through people's names as:

    john.smith

    I have added =StrConv(Fields!name.value,vbProperCase). This now brings them through as John.Smith, which is better, but is there a way of removing the full stop between 'john' and 'smith'?

    Any suggestions welcome, thanks.

  • November 19, 2014 at 2:59 am

    #1759467

    Try the REPLACE function.

    =Replace(StrConv(Fields!name.value,vbProperCase),"."," ")

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 19, 2014 at 5:21 am

    #1759493

    Worked perfectly - thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply