[AccessD] Access 2010 Switch from Form View to Datasheet View crashes.

[Jim Dettman]

David,  

Not sure if it'll make a difference or not, but as a general rule song with any programming language you want to be as explicit as possible. So I would try adding Me. To that reference and see if it makes a difference.   If that Doesn't do it I would try doing a save as text and load from text to see if the form is corrupted.   If that doesn't fix it can you do up a simple database that shows the crash? I'll try it in a later Version and if I still get the crash I'll submit it to The Access guys.

Jim

Sent from my iPhone

> On Apr 30, 2017, at 12:00 AM, David Emerson <newsgrps at dalyn.co.nz> wrote:
> 
> Hi Team,
> 
> 
> 
> I have found the problem (but not a solution).
> 
> 
> 
> It relates to a text box I have in the Form Header.  I have a combobox in
> the form header and the text box has the following control source:
> 
> 
> 
> =Nz([cboPendingOrders].[column](3),"")
> 
> 
> 
> If I remove the control source then the form doesn't crash.
> 
> 
> 
> In Form View the data from column 3 shows correctly.
> 
> 
> 
> I solved it by removing the textbox and showing the data in the Combobox
> concatenated with the original data from the combobox.
> 
> 
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
> 
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com