mixing integer and text in a text box
Neil:
1.) Beware of using a fields with names like [Section], because in reports,
there are properties called Section and Access can get confused; Alias the
field in your query to something like BookSection: Section.
2.) In your control, convert the integer to a string first using CStr()
function so that the control source would look like:
=CStr([BookSection]) & ". " & [SectionTitle]
HTH
--
Steve Arbaugh
MS Access MVP
ATTAC Consulting Group
http://ourworld.compuserve.com/homepages/attac-cg
Quote:
> I am trying to place two fields from a query into a text
> box on a report. One is an integer and one text, the
> report will recognise them both separately but not
> together. I am using
> =[Section] & ". " & [SectionTitle]
> and would like the result to look like
> 1. Section Revision list
> Can any one suggest where I am going wrong.
> Neil
