Setting Default Value in Form Field [WiredBox.Net - Office Newsgroups]

Group: Microsoft Access » microsoft.public.access.formscoding
Thread: Setting Default Value in Form Field

Setting Default Value in Form Field

Ruth 12/10/2008 2:34:05 AM

How do you set the default value if the value is an html tag - ex. default
value = <HTML>. What is the syntax? Apparently, I keep typing the wrong
syntax as it views the tag < and > as greater than/less than signs. I've
tried enclosing it in quotes, etc. What am I doing wrong? Please
help!!!....as this is only the most vital part of my app design. If users
have to enter the HTML code into each record this app will not be user
friendly. Thanks in advance for your help!

Re: Setting Default Value in Form Field

"Mike Painter" <mddotpainter[ at ]sbcglobal.net> 12/10/2008 5:15:47 AM

What are you trying to do?
Where?
In a default for a form it would be ="<HTML>"

I've written apps that put out whole web pages and never seen such a
problem.

If you want something like <tr> this is a row</tr>
then at some point you would write "<tr> & yourfieldname &"</tr>"
where yourfieldname = "this is a row"

Ruth wrote:
[Quoted Text]
> How do you set the default value if the value is an html tag - ex.
> default value = <HTML>. What is the syntax? Apparently, I keep
> typing the wrong syntax as it views the tag < and > as greater
> than/less than signs. I've tried enclosing it in quotes, etc. What
> am I doing wrong? Please help!!!....as this is only the most vital
> part of my app design. If users have to enter the HTML code into
> each record this app will not be user friendly. Thanks in advance
> for your help!

Re: Setting Default Value in Form Field

Ruth 12/10/2008 2:07:30 PM

Thanks Mike! That's EXACTLY what I'm trying to do - write web pages. I
wrote the syntax ="<HTML>" and got an error, but I'll try again. I REALLY
appreciate your help.

"Mike Painter" wrote:

[Quoted Text]
>
>
> What are you trying to do?
> Where?
> In a default for a form it would be ="<HTML>"
>
> I've written apps that put out whole web pages and never seen such a
> problem.
>
>
> If you want something like <tr> this is a row</tr>
> then at some point you would write "<tr> & yourfieldname &"</tr>"
> where yourfieldname = "this is a row"
>
>
>
> Ruth wrote:
> > How do you set the default value if the value is an html tag - ex.
> > default value = <HTML>. What is the syntax? Apparently, I keep
> > typing the wrong syntax as it views the tag < and > as greater
> > than/less than signs. I've tried enclosing it in quotes, etc. What
> > am I doing wrong? Please help!!!....as this is only the most vital
> > part of my app design. If users have to enter the HTML code into
> > each record this app will not be user friendly. Thanks in advance
> > for your help!
>
>
>

Re: Setting Default Value in Form Field

Ruth 12/10/2008 2:52:13 PM

Also Mike,

There was a way (in previous versions of Access) to connect to a website or
other server via ftp and publish files. You could also view files within a
browser window (IE) within Access. Can you do that with Access 2007?....How?

When you put out the web pages, did you get it to automatically publish or
did it render an html, text file using report?

"Mike Painter" wrote:

[Quoted Text]
>
>
> What are you trying to do?
> Where?
> In a default for a form it would be ="<HTML>"
>
> I've written apps that put out whole web pages and never seen such a
> problem.
>
>
> If you want something like <tr> this is a row</tr>
> then at some point you would write "<tr> & yourfieldname &"</tr>"
> where yourfieldname = "this is a row"
>
>
>
> Ruth wrote:
> > How do you set the default value if the value is an html tag - ex.
> > default value = <HTML>. What is the syntax? Apparently, I keep
> > typing the wrong syntax as it views the tag < and > as greater
> > than/less than signs. I've tried enclosing it in quotes, etc. What
> > am I doing wrong? Please help!!!....as this is only the most vital
> > part of my app design. If users have to enter the HTML code into
> > each record this app will not be user friendly. Thanks in advance
> > for your help!
>
>
>

Re: Setting Default Value in Form Field

"Mike Painter" <mddotpainter[ at ]sbcglobal.net> 12/10/2008 5:11:24 PM

Ruth wrote:
[Quoted Text]
> Also Mike,
>
> There was a way (in previous versions of Access) to connect to a
> website or other server via ftp and publish files. You could also
> view files within a browser window (IE) within Access. Can you do
> that with Access 2007?....How?
>
> When you put out the web pages, did you get it to automatically
> publish or did it render an html, text file using report?
>
> "Mike Painter" wrote:
>
I wrote it out as a textfile.

I've never known about using Access as a browser and would guess an FTP
connection would be via a third party.

Re: Setting Default Value in Form Field

Ruth 12/10/2008 6:19:00 PM

Thanks so much Mike!....yeah, really, you could open a web page from within
Access and view it in IE within Access (it was something about setting a file
to be opened by a specific program -- this case IE). It has been a while
since I did this. That's why I asked if it was still a feature because I
don't see it. But I really used to do this quite often in previous versions.

Anyway, thanks again for your help. You have no idea how major it was ---
HUGE!!! It worked great and I saw the same solution of outputting a text
file as the only option as well. So, I'll do that too.

Thanks again and have a great Christmas!!!

"Mike Painter" wrote:

[Quoted Text]
> Ruth wrote:
> > Also Mike,
> >
> > There was a way (in previous versions of Access) to connect to a
> > website or other server via ftp and publish files. You could also
> > view files within a browser window (IE) within Access. Can you do
> > that with Access 2007?....How?
> >
> > When you put out the web pages, did you get it to automatically
> > publish or did it render an html, text file using report?
> >
> > "Mike Painter" wrote:
> >
> I wrote it out as a textfile.
>
> I've never known about using Access as a browser and would guess an FTP
> connection would be via a third party.
>
>
>

Home | Search | Terms | Imprint Contact

Newsgroups Reader - provided by WiredBox.Net