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

W

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
 
S

Steve Huff

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

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

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
 
J

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
Click to expand...

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]
 
T

Tony Toews

W E B G U R L said:
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
Click to expand...

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
 
Top