none
Using VBA how can I determine if ms project field is bold? RRS feed

  • Question

  • Hello

    I am trying to figure out a way to get true/false return value if the Name field on a task is bold.  I have tried Font32Ex but it only allows me to set the font property, not inquire about the current state of the font in the field.

    Any ideas?

    Thanks

    Art

    Thursday, August 16, 2018 12:34 PM

Answers

  • Art,

    Bad news. Project is very limited in what it can do with respect to controlling fonts with VBA. As you found out, you can set but not "read" font formatting.

    What exactly are you trying to do? Yeah, I know, read the font format, but why? Perhaps we can figure out a work-around to get you there.

    John

    • Marked as answer by ArtPM Tuesday, August 21, 2018 1:56 AM
    Thursday, August 16, 2018 2:16 PM

All replies

  • Art,

    Bad news. Project is very limited in what it can do with respect to controlling fonts with VBA. As you found out, you can set but not "read" font formatting.

    What exactly are you trying to do? Yeah, I know, read the font format, but why? Perhaps we can figure out a work-around to get you there.

    John

    • Marked as answer by ArtPM Tuesday, August 21, 2018 1:56 AM
    Thursday, August 16, 2018 2:16 PM
  • Thanks John.  I didn't think so.  I was hoping to check the font format for reporting but I'll probably just have to set a customized field as a flag.

    Appreciate it...

    Art

    Tuesday, August 21, 2018 1:56 AM
  • Art,

    You're welcome and thanks for the feedback.

    John

    Tuesday, August 21, 2018 2:25 AM