Max Wanadoo
max.wanadoo at gmail.com
Wed Feb 25 10:15:47 CST 2009
Ha! John, Been there. Looked at them yesterday - but I love the fact that you are now also thinking Laterally! Couldn't find any way to manipulate custom properties in Forms. Do you know a way? I could only find custom properties on DB, Tables, Indexes, etc but not forms. Max Laugh more than cry. Smile more than frown. Be generous in spirit. And always stand your round in the pub! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 25 February 2009 13:15 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Find First in an Array? - The Solution Revisited -Now Tag is the Answer Max, Forms also have custom properties IIRC, and that would be the place to do what you are thinking of doing. The form's custom properties work beautifully, and you could use the form's properties custom properties to store the info about controls on that form. It was about 10 years ago when I last looked at them but I remember thinking what a cool tool. They are "well hidden" and so you can place security info in them (what I was using them for) and make it almost impossible for a hacker to find. IIRC they do have the issue of having to be set in design and then saved to make them "permanent" but if you have that ability then there they are. Keep thinking laterally! John W. Colby www.ColbyConsulting.com Denis Sherman wrote: >>> There is a generic property (limited to 2048 characters, by the way), > which can be used for anything...and can be used by anything. But using it > for multiple purposes gets to be very hairy! > > However, I was just playing around with user-defined-properties in the mdb > properties itself - for storing these multi-value strings each > formname+controlname to have its own user defined property name with the > value being the multi-value language string. Worked beautifully apart from > the limitation around the 64K size mark. > > I have another plan - just thinking it through laterally first! > > Max -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com