Concatenation of Text and Number

[diane802]

since this comes directly from my main table, does that mean i have to rename it in the main table?

[RuralGuy]

Have you tried putting what I posted in the ControlSource of a control on your report yet?

[diane802]

now its asking me for the parameter value for txtValued_Accounts etc..

[RuralGuy]

Did you rename the controls?

[diane802]

i just change the unbound text field to have countrol source show the txt in front of each...

am i supposed to change the actual names in the main table, bc it pulls directly from there as is..

[RuralGuy]

Your "unbound" control on the report should be referencing other controls on the report and notn the RecordSource directly. Those controls should be bound (have ControlSources) to the appropriate fields in the RecordSource. No renaing of elements in the RecordSource is necessary. Try adding the Me. scoping to the reference.

=Disclosures(Me.txtValued_Accounts, Me.txtBalance_Credited, Me.txtBalance_Owed, Me.txtValued_Accounts_Length, Me.txtBalance_Credited_Length, Me.txtBalance_Owed_Length)

[diane802]

IT WORKS NOW! basically, i realized that even though i have the table showing in the query, i didn't actually bring those fields into my query, so hence it could not find it!

thank you so much for all your help! hope you get out of the snow!

[RuralGuy]

You're welcome and have fun.