how to format fields so not to type in same repetitious data?

[W E B G U R L]

I have a column where I add reference to images in a folder (for the web)

I want to format the data type so that ../images/ automatically appears in the column and
then I just add the file name after this so I am not having to type this all the time

Thanks in advance

repetitious

 

[Steve Huff]

Just save the name of the image in the table then and in the query append
the full path to it.

 

[W E B G U R L]

found it!

input mask!


I have a column where I add reference to images in a folder (for the web)

I want to format the data type so that ../images/ automatically appears in the column and
then I just add the file name after this so I am not having to type this all the time

Thanks in advance

repetitious

 

[W E B G U R L]

Looks like I was wrong.

I typed in the input mask:

.../images thinking that would do it but I am missing something or not the right section



found it!

input mask!


I have a column where I add reference to images in a folder (for the web)

I want to format the data type so that ../images/ automatically appears in the column and
then I just add the file name after this so I am not having to type this all the time

Thanks in advance

repetitious

 

[John Vinson]

I have a column where I add reference to images in a folder (for the web)

I want to format the data type so that ../images/ automatically appears in the column and
then I just add the file name after this so I am not having to type this all the time

Neither a Format - which will control how the data is *displayed*
without changing what's stored - nor a Mask - which only constrains
what you can and cannot type - will work in this case.

One way is to set the Default property of the textbox to

"../images/"

and set its SelStart property to 11.

John W. Vinson[MVP]

 

[Tony Toews]

I have a column where I add reference to images in a folder (for the web)

I want to format the data type so that ../images/ automatically appears in the column and
then I just add the file name after this so I am not having to type this all the time

Not quite exactly what you want but try hitting ctrl+' in the field.
This will repeat the last entry done. You will get the file name
though too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm