Make spell check "skip" a field

[pbrown2]

Currently the below is being used for spell check on the form.

DoCmd.SetWarnings False 'turn off system warning if spell check returns no error'
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True 'turn back on the system warnings'

However, there is one field on the form that is automatically filled in when it opens with "SENGINEERING" depending upon the value in another filed (this is used later for quering) and spell check keeps stoping at this field. Is there away to modify the code to skip the "SENGINEERING" field of [Rollup]?



Thank you for any and all help,

PBrown

 

[gol4]

add it to the dictionary or change your dictionary setting to ignore caps

 

[pbrown2]

The problem is that this is on a FE. If I "add" it to my dictionary or ignor caps on my FE or the FE before it is distributed to each PC will it still work?

Thank you for any and all help,

PBrown

 

[gol4]

try to disable it the enable it

DoCmd.SetWarnings False 'turn off system warning if spell check returns no error'
Me.Rollup.Enabled = False
DoCmd.RunCommand acCmdSpelling
Me.Rollup.Enabled = True
DoCmd.SetWarnings True 'turn back o