Hi Rodney,
I assume you are copying the data to the Flex Grid control in the
Form_Activate event as I have in the demo program. If so then you need
to re-trigger that event from your Data Entry form.
The method I use is to hide the Data Entry form briefly which will
move the focus back to the Flex Grid form (assuming that this is the
only other form open) which will trigger the Form_Activate event which
will refresh the Flex Grid data. If you have a 'refresh' button or
some other suitable event on your Data Entry form the code would be
something like this.
Private Sub cmdRefresh_Click()
Save your new data to the tables (if not already done)
DoCmd.OpenForm "frmDataEntry", , , , , acHidden
DoEvents
DoCmd.OpenForm "frmDataEntry"
End Sub
The screen flickers a bit as the form disappears and then re-appears
but I think it is acceptable.
Regarding the font size, I have tried this and it works OK. How are
you changing the font size, with code or using the Custom property of
the Flex Grid control. I suggest you try changing the font size in my
demo program for one of the forms and see if that works. If it does
then it may be a problem with your own database, if it doesn't then it
may be some problem with the Flex Grid control or Windows.
HTH
Peter Hibbs.
>Hi,
>I am using the diary flex grid I downloaded from Peter Hibbs's web site.
[quoted text clipped - 20 lines]
>Thank you in advance
>Rodney
Rodney - 05 May 2007 04:19 GMT
Peter
Thank you very much it's working perfect (hope I haven't spoken to soon) at
present.
I still cann't change the font though but I not concerned about that.
Thank you again much appreciated.
Rodney
> Hi Rodney,
>
[quoted text clipped - 54 lines]
> >Thank you in advance
> >Rodney