Default Value in text boxes? (1 Viewer)

[bsnapool]

Hi All,

I am wondering what to do to put a default value in feilds which are blank. Would like a default value of 0. There is no default value in the properties of the bound text box in report view???

 

[rainman89]

if you set the default at the table level i believe it will show in the report

or you can do

=iif(isnull(yourtextboxname),0,yourtextboxname)

 

[bsnapool]

Hey,

Thanks for your reply, will try and let you know how i get on.

Cheers

 

[RuralGuy]

You can change the ControlSource of the bound textbox to:
=Iff(IsNull[YourField],0,[YourField])
...using YourField name of course.

 

[rainman89]

You can change the ControlSource of the bound textbox to:
=Iff(IsNull[YourField],0,[YourField])
...using YourField name of course.

dont you mean IIF?

 

[RuralGuy]

I sure do Ray. Thanks for the catch. My << AIR CODE >> skills need some work!

 

[bsnapool]

Hi All,

i tried this...

=IIf(IsNull([SumOfBudget Admissions]),0,([SumOfBudget Admissions]))

But coming up with an error???

Any ideas? The above formulae was in the detail of the report.

 

[bsnapool]

I have also tried setting the default value in a table, but because its a linked excel spreadsheet it wont allow the changes.

Is vba an option?

 

[RuralGuy]

Hi All,

i tried this...

=IIf(IsNull([SumOfBudget Admissions]),0,([SumOfBudget Admissions]))

But coming up with an error???

Any ideas? The above formulae was in the detail of the report.

...What error?

 

[bsnapool]

Coming up with an #Error#

 

[RuralGuy]

You have this as the ControlSource of a TextBox in the Detail section of your report and it displays #Error# instead of a value, correct? It works as described previously when bound to [SumOfBudget Admissions] correct?

 

[RuralGuy]

What is the data type of the [SumOfBudget Admissions] field?

 

[bsnapool]

You have this as the ControlSource of a TextBox in the Detail section of your report and it displays #Error# instead of a value, correct? It works as described previously when bound to [SumOfBudget Admissions] correct?

CORRECT

What is the data type of the [SumOfBudget Admissions] field?

The datatype is a number, this field is from a query.??

 

[RuralGuy]

Do you have the "=" just prior to the IIF?? You are certain some of the fields are Null?

 

[bsnapool]

Do you have the "=" just prior to the IIF?? You are certain some of the fields are Null?

Yes I have the = sign before the iif statement. The are most definatly nulls.

Its a join from 2 tables, there will be some data in one table and none in the other table.

That make sense?

 

[RuralGuy]

Sorry for asking such basic questions. What happens if you change the ControlSource to:
=IIf(IsNull([SumOfBudget Admissions]),"0",([SumOfBudget Admissions]))

 

[bsnapool]

Still comes up with #Error??

 

[bsnapool]

Is it possible to add this to the query?

 

[RuralGuy]

YES. That should work as well.

 

[bsnapool]

I have just tried this and it coming up with an error:

Cost Difference: IIf([SumOfBudget Cost]="",[BasicCost],([BasicCost]-[SumOfBudget Cost]))

This way if it is another field has a a null value then i would like to place a value of Basic cost otherwise do the calcualtion...

Sorry about this but its winding me up...