Unbound Control Mystery

[mcktigger]

Hi All

I have a report with a number of unbound controls which show a default value. The report loads fine and displays the correct values as it should. However I need to change the values on some of the controls but for the life of me can't find / remember where I set the the default values. There is no code on the report and within the properties of the unbound controls there is no default value option.

Very confused as I obviously set a default value at some point.

Any help appreciated

 

[vbaInet]

There's no Default Value on controls in reports. The Default Value property works for new records and in reports you don't manipulate data, you display them.

What you need to use is an IIF() function.

 

[mcktigger]

Hi

Thanks for the reply. I'm not going mad after all. That's what I thought but by report shows values for the unbound fields which have no control source or iif statement against them. I'm even more confused now.

Where else could they be picking up the values from? It's not on my query.

Thanks

 

[vbaInet]

Are you sure you don't have code behind your report? Or even the control?

 

[mcktigger]

I've been through every control and every report section and there is no code that sets the values of these controls. I don't understand it . The controls are showing as unbound. I've opened the report directly without calling it from a form so that rules out code on a form setting the values.

 

[vbaInet]

Upload your db and I'll have a look.

But before you do that, have you Compiled and done a Compact & Repair?

 

[mcktigger]

Hi

Db attached. If you open Rpt68AQuote you'll see a column headed TARGET (a control is in red) it is all the unbound controls in this column that I have issues with.

I've run a compact and repair and compiled with no issues.

Thanks

 

[vbaInet]

Your report and the controls are corrupt. You will need to create the whole thing from scratch and I don't mean create a new report and copy and paste the controls onto it, I mean create a new report and create new textboxes on it.

Did you have Auto Correct on?

 

[mcktigger]

Thanks I think

Never switched auto-correct on but it does look like it is on.

Where are you seeing the report corruption?

Thanks

 

[vbaInet]

If you remove the report's Record Source it still moves between records. If you drop a new textbox on the form it's fine. Both these signs indicate corruption especially the former.

And Auto Correct has been known as a culprit for causing corruption.

 

[mcktigger]

strange. I removed the record source and no records were displayed just the expected #Name? errors.

 

[vbaInet]

Corruption!