Reports Columns Help/Field Name Help

[misschanda via AccessMonster.com]

Hello,
I wrote in previous to get information on makin a 3 column report w/out
Fieldnames repeating. The code worked and it is listed below:

If Me.Left < (2 * 1440) Then
Me![FirstNameLabel].Visible = True
Me![LastNameLabel].Visible = True
Me![TitleLabel].Visible = True
Me![FirstName].Visible = False
Me![LastName].Visible = False
Me![Title].Visible = False
Me.NextRecord = False
Else
Me![FirstNameLabel].Visible = False
Me![LastNameLabel].Visible = False
Me![TitleLabel].Visible = False
Me![FirstName].Visible = True
Me![LastName].Visible = True
Me![Title].Visible = True
End If


My new problem:
The report I made comes from a query that has units in the internation
standard. The form that produces this information is ask of the measurements
however converts them to American units
For example Size(mm) will be converted to size(in). In the control source for
textbox for size(in) i have =size(mm)*0.0394.
when using the above code my american version of the report doesn't include
the conversion...

Can you guys help??

Thanks
LA

 

[fredg]

Hello,
I wrote in previous to get information on makin a 3 column report w/out
Fieldnames repeating. The code worked and it is listed below:

If Me.Left < (2 * 1440) Then
Me![FirstNameLabel].Visible = True
Me![LastNameLabel].Visible = True
Me![TitleLabel].Visible = True
Me![FirstName].Visible = False
Me![LastName].Visible = False
Me![Title].Visible = False
Me.NextRecord = False
Else
Me![FirstNameLabel].Visible = False
Me![LastNameLabel].Visible = False
Me![TitleLabel].Visible = False
Me![FirstName].Visible = True
Me![LastName].Visible = True
Me![Title].Visible = True
End If

My new problem:
The report I made comes from a query that has units in the internation
standard. The form that produces this information is ask of the measurements
however converts them to American units
For example Size(mm) will be converted to size(in). In the control source for
textbox for size(in) i have =size(mm)*0.0394.
when using the above code my american version of the report doesn't include
the conversion...

Can you guys help??

Thanks
LA

The "Size" you are looking for may not be the "Size" you are getting.

Size is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html

 

[misschanda via AccessMonster.com]

The field name is [size(mm)].
Would this still be considered 'bad'??
If so, your suggestion is to change the fieldname altogether???
LA

Hello,
I wrote in previous to get information on makin a 3 column report w/out

[quoted text clipped - 30 lines]

Thanks
LA

The "Size" you are looking for may not be the "Size" you are getting.

Size is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html

 

[Marshall Barton]

The report I made comes from a query that has units in the internation
standard. The form that produces this information is ask of the measurements
however converts them to American units
For example Size(mm) will be converted to size(in). In the control source for
textbox for size(in) i have =size(mm)*0.0394.
when using the above code my american version of the report doesn't include
the conversion...

If the report's record source query has the value in mm, the
the report text box needs to use the same expression as the
form:
=[size(mm)] * 0.0394