Access report - Finding the Control Source

Hi Experts,

I am trying to find what this is doing and where it is coming from:
=[Description] & " " & Format([CEU],"Standard") & IIf([CEU]=1," Hour"," Hours")

it is in the Control Source and is a subreport.

Please help and thanks.
Amour22015Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
It is concatenating two fields( [Description], [CEU] ) and displaying it in a textbox on your form.  

The Formate([CEU], "Standard") will format a numeric value with a comma and decimal point if appropriate.  The last IIF() statement will either append the term " Hour" or "Hours" to the description based on the value in the [CEU] field.

Not sure why this would be in a subform (can you post a screen shot of the form, subform combination) unless the individual who created the form didn't want to create a join to the table that it comes from.  This might be the case if that would have made the form non-updateable.

Is this subform linked to the main form via a master/child relationship?
0
Rey Obrero (Capricorn1)Commented:
=[Description] & " " & Format([CEU],"Standard") & IIf([CEU]=1," Hour"," Hours")

where is it coming from?
Look at the Record Source of the subreport


1. [Description] - getting the value of the field [Description]

2. Format([CEU],"Standard") -formatting the field [CEU] to standard (two decimal places)

3   IIf([CEU]=1," Hour"," Hours")  - checking the value of field [CEU], if value is equal to 1, assign a value of Hour, else assign a value of Hours
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amour22015Author Commented:
Hi,

Yes this subform is linked to several forms and is a certificate.

The client request changing text in the subform so that is why I am changing.  As for a snapshot because there are several reports.  But I can give you a snapshot of the subform?

Looks like what I am really looking for is the Description section on where this is coming from so I can change the text that is in the description?

So like because of the:
=[Description]
I first thought to look at VBA Alt-F11?
But I did not see anything that mentions [Description]

Please help and thanks.
0
Amour22015Author Commented:
Ok great this is now in TSQL and I will have to do more research to find thanks
0
Dale FyeCommented:
I'm confused.  What did Rey say that I didn't say in my response?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.