How to stop spell checker checking multiple records?!

[Cleggy]

Hello,

I'm experiencing erratic behaviour from the spell checker (Access 2000).

I'm in form view and when I invoke the spell checker one of the following occur:

It spell checks the current record and stops (This is what I want, and what I belive it is supposed to do)

It spell checks the current record then moves to the previous record, then stops.

It spell checks the current record then cycles through all the records in the recordset, not just the current record.

Anyone know what might be causing this behaviour? (could it be something I've set on the form?)

Is there any way through code to restrict the spell check just to the current record (or even just a few fields of the current record so I can program in which fields to ignore rather than the user having to click the button on the spell check dialogue?)? I could then use a command button to check just the current record and stop users using the F7 key or the Tools > Spelling menu option.

Any advice or tips would be appreciated.

Cheers!

 

[tonyflavell]

Just a thought! - Have you checked the Form 'Cycle' property is set to 'Current Record'

 

[Cleggy]

Thanks for the thought but yes, 'Cycle' is set to 'Current Record'.

If I spell check a record that isn't the last in the recordet it checks the current record and the next ones in the recordset.

I'm not sure if there are spell checker settings I've missed somewhere along the line or what. If I start the checker on the last field of a form it ignores spelling mistakes in previous fields on the same record.

The spell checker is checking the current field and any subsequent fields for the current record and then all fields in any further records in the recordset. What I want it to do is check all fields for the current record only.