Unbound Controls set in Code vs Bound Data

[lameid]

This may be a bit of an oversimplification but assuming there are multiple controls or paragraphs to setup is it more efficient to use calculations or Literals in code...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   Me!TheControl = "Some Text " & Me!PipeIn1 & "Some More Text"
End Sub

Alternately the below control source may be used.

=Replace(TextField, "<PipeIn1>", PipeIn1)

The real issue arises in that there are permutations of "Some Text" or TextField that have to be accounted for.

I have been told that the former methodology is faster. I am not sure I am convinced but it is no trivial matter to test so I was hoping for a few good opinions.

These report nuances is just something I have not had to play with before.


Then I was not sure about FormatCount, would it be appropriate to only set values on the first pass which if I understood what I read correctly is 0?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   If FormatCount = 0 Then 
      Me!TheControl = "Some Text " & Me!PipeIn1 & "Some More Text"
   End If
End Sub

 

[dhookom]

I have a tendency to put data in tables. I would use the Replace() to perform you merge functionality.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[lameid]

Thanks Duane.

Any thoughts on the FormatCount to only run once instead of multiple? I see that you are in most cases favoring the bound control approach but I have no experience with formatcount and was hoping for nuance insight. Thanks again!

 

[dhookom]

I wouldn't worry about the format count in this case. I believe it is mostly used in cases where values are added or counted.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016