John Bartow
john at winhaven.net
Mon May 23 13:51:11 CDT 2005
Rocky, It was just a general idea for you. Just using the UI you would design and save the report, then use File | Save as html or in newer version File | Export. This can be done through code but I don't remember where I've done it (or I'd post it). Posting it on the web is probably better because you can update it whenever you desire. (Plus you don't have to deal with so many memo fields in your db.) John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Monday, May 23, 2005 12:47 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Lots of Text in a Form John: I think what we're going to do now is put all the resource info on a web site. And just have hyperlinks in the program to various resources pages on that site. That way after the product is published we can still change the content every day if needs be. This field of sleep medicine is really fluid. What do you think of that approach? (I'm installing Front Page 2003 as we speak.) I'm still curious, though, how you output that report to the screen with the hyperlinks active. Thanks and regards, Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 ----- Original Message ----- From: "John Bartow" <john at winhaven.net> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Monday, May 23, 2005 9:53 AM Subject: RE: [AccessD] Lots of Text in a Form > Rocky, > You could present your reports as an html page where the links would be > active. > > > John B. > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - > Beach Access Software > Sent: Monday, May 23, 2005 11:22 AM > To: AccessD at databaseadvisors.com > Subject: [AccessD] Lots of Text in a Form > > Dear List: > > We are adding a database of resources and information to The Sleep > Advisor. > What I thought I would do is make a continuous form with Can Grow text > boxes > so that the subjects could be displayed with a vertical scroll bar and the > boxes would grow and shrink like a report (the text box is bound to a memo > field in the Resources table which holds the actual text). > > But now I find out you can't do that. Can Grow doesn't work in a form. > > I want this info in a form because it contains lots of hyperlinks which > won't work in a report. But now I'm stumped. > > Anyone got any ideas? > > MTIA, > > Rocky Smolin > Beach Access Software > http://www.e-z-mrp.com > 858-259-4334 > > > I could set the height of the text box dynamically > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com