Formatting for printout

[Ajay]

Hi,

Looking for some help. There is a date field in my timeline which show
'NA' when date is not entered in it. I want to show/print it as
spaces. Please let me know how I can do that.

Similarly, there is a numeric field which I want to show as spaces if
it is zero.

Any inputs to this project novice would be greatly appreciated.

Thanks, Ajay

 

[Jan De Messemaeker]

Hi,

For both questions, the aonly answer is use a text field with an appropriate
formula f.i.
iif([Number7]=0,"",cstr([Number7])

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

You will need to create and use a custom Text field to do this. Numeric
fields always show 0 as the default and date fields always show NA if they
have nothing in them.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Hi,

Looking for some help. There is a date field in my timeline which show
'NA' when date is not entered in it. I want to show/print it as
spaces. Please let me know how I can do that.

Similarly, there is a numeric field which I want to show as spaces if
it is zero.

Any inputs to this project novice would be greatly appreciated.

Thanks, Ajay

__________ Information from ESET Smart Security, version of virus
signature database 4878 (20100218) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4878 (20100218) __________

The message was checked by ESET Smart Security.

http://www.eset.com