Standard responses

[SueBK]

On a number of my forms, I have preferred or standardised text for responses under different circumstances (ie if "this" type "ABC"; if "that" type "XYZ").

I have saved these in autocorrect; however, autocorrect is machine based coding. If I type "STBC" I get "search to be conducted", but no-one else using the database will.

I'm wondering is there a way to (ie how do you) program autocorrect functionality that is part of the database, rather than part of the user's Office settings?

 

[SueBK]

Anyone got any ideas?

 

[John Big Booty]

You could use some code in the your first filed's On Change event, along the lines of;

If Not IsNull(Me.YourSecondField) Or Me.YourSecondField <> "" Then [COLOR="SeaGreen"] 'Check for and prevent changes
                                                                    'If Second field already hold a value
                                                                    'Remove this test if not required[/COLOR]

    Select [URL="http://www.techonthenet.com/access/functions/advanced/case.php"]Case[/URL] Me.YourFirstFiled
   
    Case "This"
        Me.YourSecondField = "ABC"
    Case "That"
        Me.YourSecondField = "XYZ"
    Case Else
        Me.YourSecondField = "LMN"
    End Select

End If