Unbound Field

[kitty77]

I'm on a report and have an unbound field. When I put info in the field, then move away to another field, the data in the unbound field disappears?

 

[theDBguy]

How exactly are you putting the info in the unbound field?

 

[kitty77]

How exactly are you putting the info in the unbound field?

just entering it in...

 

[theDBguy]

just entering it in...

While in Report View?

 

[kitty77]

yes

 

[LarryE]

An unbound field is unbound. It's not going to retain a value. Calculate the value of the field and put the calculation in the Control Source of the field.

 

[kitty77]

it's just text... So, no way to retain the value?

 

[kitty77]

I guess I will just have to use a bound field instead... Did not really want to save the data.

 

[theDBguy]

I guess I will just have to use a bound field instead... Did not really want to save the data.

Will the data change every time you view the report?

 

[kitty77]

Yes, it will be different.

 

[theDBguy]

Yes, it will be different.

In that case, you might consider using code to prompt the user what information they want to enter in the textbox as soon as the report opens. That should keep the information displayed as long as the report is open, but they won't be able to change it again, unless you add a button to do that.

 

[Pat Hartman]

Why are you typing data into a report? Why is the data not coming from a table? If it is ONE field, add an unbound control to the form that opens the report and reference that:

=Forms!someform!somecontrol