Circular Reference using UCase(), Following a Video Tutorial

[Modify_inc]

I’m following a video tutorial for Access 2010 and am stumped at this one error that continues to popup.
The lady performing the presentation shows every detailed step, so I’m certain I’m not missing anything.

The example is a report in Access and she is demonstrating changing the FullName field to all uppercase. Should be pretty simple I would think.

She says to go to Design View, select the FullName field, open properties, select Data tab, and then select the Control Source box.

In the Control Source box, she mentions that it’s better to delete the name and start with an unbound field.

I then open Expression Builder, and select the ‘Built-In Functions’, Select ‘Text’, followed by ‘UCase’.

The Expression after entered correctly and exactly as she has hers is:

UCase([FullName])

I hit OK, and I immediately get the drop down error next to the FullName field, which informs me of the 'Circular Reference error'. If I continue and view the report, the FullName field list displays ‘#Type!’.

I have googled the above error and understand basically what might be going on with my limited knowledge of Access, but what I don’t understand is how is it working for her and not for me!

Anyone able to clue me in that has more knowledge of Access?



Thanks
Mike

[June7]

Give the textbox a name different from the field used in the expression. Another technique to show all characters as upper case is to use the Format property with the > character. Just enter that character into the bound textbox Format property and all characters in the textbox will display as upper case. This is only a display setting (as is using the UCase function in ControlSource expression) - it does not alter how the data is stored in table. The Format property alternative will not have circular reference conflict.

[Modify_inc]

Give the textbox a name different from the field used in the expression. Another technique to show all characters as upper cause is to use the Format property with the > character. Just enter that character into the bound textbox Format property and all characters in the textbox will display as upper case. This is only a display setting (as is using the UCase function in ControlSource expression) - it does not alter how the data is stored in table. The Format property alternative will not have circular reference conflict.

The > works great thanks for the tip.

I'm not certain about your directions when you say "give the textbox a name different from the field used in the expression." Remember I'm completely new to Access.

If I change the name in the textbox field, it also changes the name in the Control Source field, so I'm right back where I started, just with a different name.

I'm sure I'm missing something here, because I'm not fully grasping how or what Access is doing behind the scenes.

Mike

[June7]

All controls (textbox, combobox, listbox, label, tab, line, box, subform/subreport, graph, etc) have a Name property. You can give each any name you want. Data controls (textbox, listbox, combobox) also have a ControlSource property (labels have a Caption). Sometimes a bound data control is created with the Name property set to the field name that the ControlSource property is bound to. Change the Name property to anything, like tbxFullName.

[Modify_inc]

All controls (textbox, combobox, listbox, label, tab, line, box, subform/subreport, graph, etc) have a Name property. You can give each any name you want. Data controls (textbox, listbox, combobox) also have a ControlSource property (labels have a Caption). Sometimes a bound data control is created with the Name property set to the field name that the ControlSource property is bound to. Change the Name property to anything, like tbxFullName.

Thanks for the clear and concise directions.

I was able to identify what I was doing wrong, no thanks to the lady in the video, she never mentions or shows this one critical step.

I needed to go the the 'Other' tab on the 'Property Sheet' and change the name from there to something other than the default 'FullName' it was using.

This is the second time she has done something that she missed a critical step, luckily the previous I was able to discern myself. Overall though she has been pretty helpful.

If you know or recommend any other training videos for Access I would love to hear them.

Thanks again for your assistance!

[June7]

Look through this collection http://datapigtechnologies.com/AccessMain.htm

I have found a lot of helpful stuff from Allen Browne http://allenbrowne.com/tips.html and Stephen Lebans http://www.lebans.com/

Review
http://forums.aspfree.com/microsoft-...es-208217.html
http://www.developerbarn.com/communi...-database.435/

[Modify_inc]

Look through this collection http://datapigtechnologies.com/AccessMain.htm

I have found a lot of helpful stuff from Allen Browne http://allenbrowne.com/tips.html and Stephen Lebans http://www.lebans.com/

Review
http://forums.aspfree.com/microsoft-...es-208217.html
http://www.developerbarn.com/communi...-database.435/

Just wanted to let let you know those links were very helpful, thanks again!