Connecting Tech Pros Worldwide Forums | Help | Site Map

automatically replace 'sf' with 'sales faculty'

17PAULF@O2.CO.UK
Guest
 
Posts: n/a
#1: Jun 21 '06
im inexperienced in this so bare with me please...

im trying to create a database and i need to use a code, basically i
want to be able to type in, for example, 'sf' and i want the software
to replace this with 'sales faculty'

i need help with the code i need to type and wher to type it please...
i have the field name as faculty, and the data type set as 'Text' other
than that everything else is as it was; i havent played around with any
thing in the 'general' tab or the 'Lookup' tab

fredg
Guest
 
Posts: n/a
#2: Jun 21 '06

re: automatically replace 'sf' with 'sales faculty'


On 21 Jun 2006 09:30:59 -0700, 17PAULF@O2.CO.UK wrote:
[color=blue]
> im inexperienced in this so bare with me please...
>
> im trying to create a database and i need to use a code, basically i
> want to be able to type in, for example, 'sf' and i want the software
> to replace this with 'sales faculty'
>
> i need help with the code i need to type and wher to type it please...
> i have the field name as faculty, and the data type set as 'Text' other
> than that everything else is as it was; i havent played around with any
> thing in the 'general' tab or the 'Lookup' tab[/color]

Why not use AutoCorrect?
Tools + AutoCorrect Options

Replace sf with sales faculty

Make sure the form control's AllowAutoCorrect property is set to yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
google@giblin.co.uk
Guest
 
Posts: n/a
#3: Jun 21 '06

re: automatically replace 'sf' with 'sales faculty'


Highlight the column and press control+H and do a search and replace.

17PAULF@O2.CO.UK wrote:[color=blue]
> im inexperienced in this so bare with me please...
>
> im trying to create a database and i need to use a code, basically i
> want to be able to type in, for example, 'sf' and i want the software
> to replace this with 'sales faculty'
>
> i need help with the code i need to type and wher to type it please...
> i have the field name as faculty, and the data type set as 'Text' other
> than that everything else is as it was; i havent played around with any
> thing in the 'general' tab or the 'Lookup' tab[/color]

Closed Thread