Distinct modes of gene regulation by a cell-specific transcriptional activator