[AccessD] Lots of Text in a Form

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




More information about the AccessD mailing list