criteria used in report label (little diff from other posts on this)

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Guys,

(Office XP - Access)

I used the allen browne method for getting the criteria pasted to the report
header label.

I created a text box in the header with "=PresetNAME"

However here is the problem....

My report is based on a query that prompts me to enter a PresetName aka name
of a guitar patch
could be Metallica or Metallica-One or Pink Floyd or Pink Floyd - Money
Is there a way for me to limit the data sent to the text box in the header,
to only take everything before the first space in the PresetName or
everything before a hyphen???

TIA,
_Bigred


.

Relevant Pages

  • Re: Reset Page of Pages in Multipage reports
    ... which is the Report Number in the header - reports ... Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant ... Dim GrpPage As Integer, GrpPages As Integer ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... If you don't want to show the header on the first group, ... Open the report in design view. ... I have a header of shutdown in front of the whole list but the two lists ... The Subreport will only show as many rows as will fit in the area I delegated ...
    (microsoft.public.access.reports)
  • Re: Report with Sub-Report with NO-DATA on Sub-Report
    ... held in the header/footer of the report. ... primary header ... detail section followed by the subreport. ...
    (microsoft.public.access.reports)
  • RE: Split worksheet into multiple worksheets
    ... Dim lngRow As Long, lngLastRow As Long, varTemp As Variant ... The report I tested it on consisted of 3 cost centres. ... split the first 2 perfectly and it pulled the header of the 3rd into a new ...
    (microsoft.public.excel.programming)
  • Re: subreport displays only once
    ... The Page Header is a page-oriented section, ... > You will basically re-create the orders form as a report... ... You will see that the subform only shows up once. ... >> LinkMasterFields/LinkChildFields is being applied correctly, ...
    (microsoft.public.access.reports)