Robin-
It would have been simpler to just bind the control to the field and set the Format property to display it as you want it. It's silly to make a function call to do that.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 26, 2015, at 9:20 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Robin
---In MS_Access_Professionals@yahoogroups.com, <robinski@westnet.com.au> wrote :
G'day Bill,
Absolutely brilliant! I would not have thought of that in 1000 years!
Many thanks,
Robin Chapple
At 27/01/2015 02:32 AM, you wrote:
Glad I could help. I've stumbled across this before. One thing that will make it more evident next time is if you have your Options>Object designers>error checking turned on. The control should show a little flag (default is bright green) in the corner of the control indicating an error. Click on the pop-up and you will see the "Circular Reference" error pop up.
Also, make it a practice that whenever you use an expression as a ControlSource that you use a naming convention to name the control. Wizards and such will simply use the field name which is usually okay, but can cause unexpected problems.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <robinski@westnet.com.au> wrote :
G'day Bill,
Absolutely brilliant! I would not have thought of that in 1000 years!
Many thanks,
Robin Chapple
At 27/01/2015 02:32 AM, you wrote:
I bet I know what's wrong. The control is probably named YearStart. That creates a circular reference. Change the name of the control to something like txtYearStart.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar