relatively simple question (1 Viewer)

[mikeder]

I have a relatively simple question. I have created a report with several fields, one of which is a Project Manager field. What I want to be able to do is this:

If there is no Project Manager assigned to a project, instead of having a blank field if no project manager is assigned, how do i do it so that it defaults to saying "Not Assigned"?

Thanks

 

[Jon K]

Change the Control Source of the Project Manager text box in the report to:-

=Nz([Project Manager],"Not Assigned")

 

[mikeder]

thanks but...

currently the project manager text field contains the following:

Concatinate_Names.NAME

what it is doing is combining the first and last name of the project manager. If I input your suggestion won't this mess things up?

 

[mikeder]

it didn't work

what i entered into the text box source control was the following:

=Nz([Concatinate_Names.NAME],"Not Assigned")

However, the report still displays a blank for the project manager if no project manager was entered.

any other suggestions?

 

[mission2java_78]

Re: it didn't work

=IIF(Not IsNull(Me.txtProjManager), Me.txtProjManager, "Not Assigned")

Jon

 

[mikeder]

where do i input this

Thanks for your help,

where should i be typing this code in? the text box control source? i tried this one and it didn't work.

Can you tell me where i should be typing this code into?

thanks