[AccessD] I do not understand this

Or could it be that smpleSizeAll is only in the Report's source data and not
an actual control? For a report it needs to be on the report even if hidden.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: Re: [AccessD] I do not understand this
Date: 24/03/05 14:44

>
> Hi Joe
>
> I had a look again, I hadn't noticed this is a report.
> Could it happen that SmpleSizePieces is both a field and a textbox?
> Can SmpleSizePieces contain an empty string?
>
> Try this:
>
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
>     If Me.SmpleSizeAll.Value = True Then
>       Me.txtSmplSize = "All Pieces"
>     Else
>       If Me.SmpleSizePieces.Value <> 0 Then
>         Me.txtSmplSize = "Samples: " & Me.SmpleSizePieces
>       Else
>         Me.txtSmplSize = "No Samples Needed"
>       End If
>     End If
> End Sub
>
> /gustav
>
> >>> jmhla at earthlink.net 03/24 8:01 am >>>
> I built the following code using the autocomplete in the VB editor.
> Why
> can't Access find the smpleSizeAll in the code?
>
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
>     If Me.SmpleSizeAll.Value = True Then
>     Me.txtSmplSize = "All Pieces"
>         Else
>     If Me.SmpleSizePieces.Value <> 0 Then
>     Me.txtSmplSize = Me.SmpleSizePieces
>         Else
>     Me.txtSmplSize = "No Samples Needed"
>  End If
>  End If
>
>
> End Sub
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2